How to retrieve particular cell data in excel sheet ?without importing method.
Answer Posted / ram.polavarapu
'count the number of colums
cc=browser("").page("").webtable("").columcount
'count the number of rows
rc=browser("").page("").webtable("").columcount
for i=1 to rc
for j=1 to cc
'to retrieve all data from excel sheet
n=browser("").page("").webtable("").getcelldata(i,j)
print n
'for example we need to retrieve from 2-row 5-colum
m=browser("").page("").webtable("").getcelldata(2,5)
print m
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Describe the differences between functions and actions in UFT?
How to export quicktest professional results to an .xls file?
How do you do batch testing in wr and is it possible to do in qtp, if so explain?
How to attach a file to TD?
how did u use automating testing tools in ur job?
i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji
I want to do QTP Certification what is the pattern of Question paper.
What are the 3 main stages involved in testing with qtp?
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
What are the flaws in water fall model and how to overcome it?
How can you write the scripts that operate on different objects depending on run-time information?
How the exception handling can be done using quicktest professional (qtp)?
What is data driver in qtp? Where we use it?
Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.