The xls contain data. how to get number of columns form
the sheet?
- 4 Answers
- 13788 Views
- Virtusa, I also Faced
- E-Mail Answers
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
What is the framework your company is following. What is the reason. Explain why key word driven frame work is chosen.
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
what is review
What are the technologies supported by qtp?
when I was doing the web testing with QTP using with standard checkpoint the Object selection -checkpoint properties dialog box not displaying pages and links hierarchical order. Could you please tell me. thanks
How may types of defects identify application or your currently working application?pls give me answer..
What is quicktest professional (qtp)?
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.
Hello friends..... On which areas of an application we can not test with QTP
What are parameterizing tests?
What is quicktest professional (qtp window?
What is the syntax for how to call one script from another?
How to use the object spy in quicktest professional 8.0 version?
