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


Please Help Members By Posting Answers For Below Questions

What is the diff between image and bitmap check point?

586


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

1573


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

2339


what is vmodel?advantages and disadvantages of vmodel?

1607


What are the different types of checkpoints?

574






Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji

1310


How will you declare a variable in qtp?

545


How to associate shared object repository to test in qtp?

494


Define object spy ?

553


How would you export a script from one pc to another in qtp?

648


What is the limitation to XML Checkpoints?

1595


Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

1423


explain keyword driven framework with banking domain?

1549


What is quick test pro?

582


What is QTP scenario.

1717