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 Associate Repository in QTP 9.2 ?
before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...
What is expert view and keyword view?
If object is not recognized by qtp but the object is standard object what is your approach?
assume i have few url link how will i dynamically call then using descriptive programming?
Explain object spy in qtp.
How many types of actions are there in quicktest professional?
how to use the QTP choose the data from oracle? e.g. i input the identity card NO. this will be add new record in the database ,and now i want get this record's prime key.
Explain the concept of object repository and how quicktest professional (qtp) recognises objects?
How many tabs are available to view your test in a test pane and what are they?
I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?
1--How many functions u develop 2--What is an array 3-- where is ur server 4--U involved in unit testing 5--how ur test the background colour using QTP
How to run a test using quicktest professional?
What is TOM in QTP?
How to find a window is minimized or not