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

how did u use automating testing tools in ur job?

0 Answers  


How to handle Java tree in QTP?

0 Answers  


Explain about Standard output value, Text output value, database o/p value, Xml O/p value, Xm o/p Value

1 Answers   TCS,


Can anyone tell me what is the equivalant method to be used in QTP for "web_obj_get_text" used in winrunner. My winrunner code is below. set_window("Confirm Add Subscriber"); rc = web_obj_get_text("Add subscriber:","#8","#1",orderID,"The order number is","\.",1); basically I need to retrieved the "orderID " from a string present in 8th row & 1st col of table "Add subscriber"

1 Answers  


How can I use the value retrieved by OUTPUT VALUE check point as Input for other Actions?

1 Answers   Motorola,






how to capture data from images in QTP and produce them in excel sheet?

3 Answers  


Tell me the difference between QTP9.2, QTP9.5 and QTP10.0

1 Answers   Genpact, HSBC,


Pls anyone, tell me the script in QTP to find the number of links, and images in a webpage. Verry very urgent. I shall really be very thankful

3 Answers  


what is the difference between invoke application and system.util.run

24 Answers   HP, Syntel,


how to merge 2 object repositories in qtp 9.0.what is use of merge and y merge is used?

1 Answers  


how to retrieve data from flight resevation->reports

2 Answers   Wipro,


DIFFERENT RUN MODE IN QTP..1-VERIFY MODE 2-UPDATE MODE 3- dEBUG MODE. My question is in whic sitution we use these modes Explain me with example

1 Answers  


Categories