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 to convert 100 into hundred repees only and viceversa

1704


How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)

2141


can u please explain what is the exact difference between qtp8.2 and 9.0

1928


unique properties of button,edit box, radio button,check box?

4161


what is the difference between the modular framework and datadriven frame work

2177


How you can replace string in qtp?

827


www.icici.com after this home page wll came, in this page what r the items we r going to test for manual and what the element we r test for QTP... explian clearly with example

1773


How to find the length of the string in qtp?

808


How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

1767


what is ODC and GDC?

7639


suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1625


How does qtp identify gui object?

800


Can we record using all the modes in a single script? Explanation with example is appreciated

1648


What is the architecture of your project? Can any one answer for this question plz........

1613


Tell some commonly used Excel VBA functions?

846