Hi All,

I'm Akshaya here, could anybody please help me regarding
how to import the excel sheet to run time datatable. But
Pl. keep it in your knowledge is that excel sheet is opened.

Thanks,

Akshaya Madali
9823213538

Answers were Sorted based on User's Feedback



Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / sanu

It is not possible to import one excel sheet when it is
open. u should close it b4 try to do the same.

Is This Answer Correct ?    5 Yes 0 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / thirupathi ganguly

Hi Akshaya,

This is Thirupathi,iam working on QTP regarding your
question iam sending you answer
If any questions on QTP Call me on my mobile NO. 9922019467

DataTable.ImportSheet "C:\Test1.XLs" 1,1

1- is Destination Sheet ID( to Data Table)
1- is Source sheet id ( from Excel Sheet)

Regards,
Thirupathi Ganguly

Is This Answer Correct ?    1 Yes 1 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / suresh

datatable.import "D:\Document and setting\test1.xls"

Is This Answer Correct ?    1 Yes 2 No

Hi All, I'm Akshaya here, could anybody please help me regarding how to import the excel s..

Answer / siraj

FOR IMPORTING PARTICULAR SHEET FROM THE EXCEL BOOK.
--------------------------------------------------
Datatable.importsheet "D:\test1.xls",1,1

FOR IMPORTING WHOLE EXCEL BOOK(DEFAULT 3 SHEETS)
------------------------------------------------
Datatable.import "D:\test1.xls"

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More QTP Interview Questions

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

0 Answers  


iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?

0 Answers   Infosys,


how can you write a script without using GUI in QTP?

5 Answers   Ordain Solutions,


What is quicktest professional window?

0 Answers  


How to Import data from a ".xls" file to Data table during Runtime.

1 Answers  






what frame work you are following?

0 Answers   Wipro,


can anyone answer this question ........in the DICTIONARY OBJECT....i created the dictionary object in reserved object ok....here i have some sets of values ...now i want to retrieve the item i done too ok.......here my question is now i saved the test and close the qtp tool ,again i opened now i retrieve the same item in the dictionary is it possible ????. friends when i try to do this i am getting empty message box i mean no value will be retrieved ......ans me any one plz...

1 Answers   FSS,


how to write vbscript on web applications in qtp. explian with one example?

4 Answers   Wipro,


How to map Test cases to the script? Please do anwser urgently?Thanks

3 Answers  


why you have standardized functions? plzzz guys with real time exp. do answer

0 Answers  


what is the use of automation objective model?where is used? plz tell me

2 Answers  


how can i impliment error handling in QTP?

5 Answers   Ordain Solutions,


Categories