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
What is the diff between image and bitmap check point?
Dear sir, i want to perform a QTP automated testing for mechancial engineering software like msc adams, msc nastran this softwares will help for mechanical engineering design analysis>> i know oad runner win runner, test director, QTp>> but i dont know how to use for automation
I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error
what is vmodel?advantages and disadvantages of vmodel?
What are the different types of checkpoints?
Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji
How will you declare a variable in qtp?
How to associate shared object repository to test in qtp?
Define object spy ?
How would you export a script from one pc to another in qtp?
What is the limitation to XML Checkpoints?
Hi, Can we open a test in qtp10 which is saved in qtp 9.2?
explain keyword driven framework with banking domain?
What is quick test pro?
What is QTP scenario.