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 smart identification in QTP?
What are the Test design techniques you uses in ur project?
How can I change object description or check point values in qtp?
describe some problems that u had with automating testing tool?
what function you write to do database testing with the help of qtp?
what is the frame work in J-meter?
how will load the object during runtime?
hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)
What are the differences between quicktest professional and winrunner?
What is recovery scenario in qtp?
On the website, the protocol has been changed https: to https what you will do? Tell me your approach?
How to use parameterization in qtp?
Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B
What is expert view in qtp?
If the objects hierarchy is changing from build to build, then how you will handle that condition?