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
Diff b/w Health care domain and Banking Domain?
how to compare two bitmaps( 1. clients requirement & 2. Designed by dev) in qtp 8.2 wann clear steps
What is the Command used to start the QTP
Your roles and responsibilities and daily tasks? (As automation tester)
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
What are parameterizing tests?
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji
What is active screen?
What are the different recording modes and how do they work?
Explain the concept of object repository and how quicktest professional (qtp) recognises objects?
What is quicktest professional?
Where we use data driver in qtp?
I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?
How to get popup error message.