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
I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance
Hi ,Can any one pleas explain how to test splash objects using QTP?
What are the steps involved in the recovery scenario wizard?
Is it possible to merge two object repository files in qtp?
How to replay a script in qtp?
what is Property......End Property loop? how to write sript for it in QTP
What are the different types of action?
How to find the length of the string in qtp?
i have doubt suppose iam purly working in manual, when i will get work to do on sql and performence testing? pls any one clarify doubt?
What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????
Define object spy ?
what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?
what and how to answer for the question "tell me about yourself ?" for 3 years experience. can anyone say inj detail please... its urgent
What is the default add-ins in qtp?
How to get popup error message.