Can I import a excel sheet in Action1 datatable? How?

Answers were Sorted based on User's Feedback



Can I import a excel sheet in Action1 datatable? How?..

Answer / nagk24

we should not give parantesis

datatable.importsheet"path of excel","excell sheet name","action id(or)action name"
datatable.importsheet"d:\data.xls","sheet1","Action1"

Is This Answer Correct ?    9 Yes 0 No

Can I import a excel sheet in Action1 datatable? How?..

Answer / kiran

yes u can import an excel sheet into datatable

datatable.importsheet("path of excel file",excel sheet name",sheid)

for ex:datatable.importsheet("c:\products.xls","sheet1",2)
hear 2 means: action sheet id

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More QTP Interview Questions

There are some links on the web page,write a script to count and click those links and check the text on the page displayed on clicking the links.

3 Answers   Tech Mahindra,


Hi, Can any one explain what is mean by Driver Script? is it AOM?

4 Answers   CTS,


Can any body tell me how can I choose the share object repository and per action object repository mode. Please give me with steps.

4 Answers  


w is fragmentation and paging

1 Answers   MBT,


What is the use of ordinal identifier in qtp?

0 Answers  






how to test a java project throughqtp?while testing a vb project we generally do vb scripting. but while testing java project do we use java script .plz some one can send me the manual for it my email roy_samata@yahoo.com thanks in advance

1 Answers  


how to use import and export sheet methods in qtp

1 Answers  


Recovery Manager means..?

4 Answers  


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

0 Answers  


how to create the varibles and how these are connect to qtp? plz tell me

3 Answers  


I'm facing this problem while automating my application..its a web based apps.. In my application there are few webtables are displaying in the page.In the different cells there are links and action buttons.Problem is there is link in different web tables corresponding to one name.Hence the properties of the objects(say a link) are same except the x,y co ordinate of the object.So my script is not able to distinguish between the two links present in different cells of web tables with same name.Kindly help on this..

3 Answers  


I want to install qtp software in my system, My operating system is vista . Anybody please suggest me how to get QTP software with licence key

2 Answers  


Categories