The xls contain data. how to get number of columns form
the sheet?

Answer Posted / basha

for global sheet

rowcount=datatable.globalsheet.getrowcount
msgbox (rowcount)


for action sheet

rowcount=datatable.localsheet.getrowcount
msgbox (rowcount)

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)

1421


Explain sub procedure of vbscript.

581


What are the different types of qtp test assets and their extensions?

587


Explain the concept of object repository and how QTP recognizes objects?

544


Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak

1612






How to analyzing test results using quicktest professional?

560


Can testing be done on the production system, or will a separate test system be required? How are browser caching, variations in browser option settings, dial-up connection variabilities, and real-world internet 'traffic congestion' problems to be accounted for in testing?

611


Tell some commonly used Excel VBA functions?

587


Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

1546


How to creating an output value using quicktest professional?

535


How will you report the bug and explain the defect tracking sheet you handled?

2540


How you are developing the script? Using record and play back or manual?

624


What is the meaning Work bench?

1756


how to write xml output check point bu useing descriptive programing .means without useing output check point

1646


I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?

1362