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

we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?

1595


Analyzing the checpoint results?

607


What is the use of sendkeys and what are send keys

1967


what is the hierarchy to use properties in descriptive programming

1514


Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?

1533






how will load the object during runtime?

1597


Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln

1408


how to compare two bitmaps( 1. clients requirement & 2. Designed by dev) in qtp 8.2 wann clear steps

1683


Hi All, I need code for how to execute qtp scripts from excell sheet

1473


How to indentify MS-Word objects like Menubar, Toolbar, table/columns/rows/cells etc within Word document, using QTP?

1824


when u script reveiwing in which area u more concentrates?

1428


Explain measuring transaction.

598


How do you create regression test packs?

624


how will you check how many members visited the website www.infosys.com?

1492


There is an excel file of 1 to 100 sheets how you will iterate through it?

541