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


Please Help Members By Posting Answers For Below Questions

What is Associate Repository in QTP 9.2 ?

593


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...

7203


What is expert view and keyword view?

617


If object is not recognized by qtp but the object is standard object what is your approach?

581


assume i have few url link how will i dynamically call then using descriptive programming?

1590






Explain object spy in qtp.

579


How many types of actions are there in quicktest professional?

504


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.

1312


Explain the concept of object repository and how quicktest professional (qtp) recognises objects?

599


How many tabs are available to view your test in a test pane and what are they?

553


I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?

585


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

1532


How to run a test using quicktest professional?

520


What is TOM in QTP?

1798


How to find a window is minimized or not

1434