Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 smart identification in QTP?

1009


What are the Test design techniques you uses in ur project?

1907


How can I change object description or check point values in qtp?

962


describe some problems that u had with automating testing tool?

1754


what function you write to do database testing with the help of qtp?

1765


what is the frame work in J-meter?

2061


how will load the object during runtime?

2018


hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)

1808


What are the differences between quicktest professional and winrunner?

945


What is recovery scenario in qtp?

953


On the website, the protocol has been changed https: to https what you will do? Tell me your approach?

946


How to use parameterization in qtp?

1021


Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B

3312


What is expert view in qtp?

997


If the objects hierarchy is changing from build to build, then how you will handle that condition?

996