The xls contain data. how to get number of columns form
the sheet?
Answer Posted / basha
for outside xls sheet we have follow below
datatable.addsheet("Sheetname")
datatable.importsheet("sheetname",sheetid,"sheetpath")
rowcount=datatable.getsheet("sheetname").getrowcount
msgbox(rowcount)
for globalsheet
rowcount=datatabe("GlobalSheet").getrowcount
msgbox (rowcount)
for actionsheet
rowcount=datatable("LocalSheet").getrowcount
msgbox (rowcount)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
what is meant by source control?
How to handle the exceptions using recovery secnario manager in quicktest professional?
Explain the benefits of quick test pro(qtp)?
Why is action split used by qtp?
How you are developing the script? Using record and play back or manual?
how to create flat file datasubmission in qtp
Differences between text and test area checkpoints?
Which functionalities of QTP used in banking project? pls any say answer?
I want two test two agents login for the flight website. Here is the scenario: I want to go through 1-3 rows for one user login and other user login I want to go though 3-5 rows. How would you set this up in qtp. Thank You
how to download mercury qtp9.2 ny internet ?
What is action? How many types of actions are there in qtp?
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
What is difference between shared and local object repository?
What is the virtual object?
what function you write to do database testing with the help of qtp?