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

Hi, When I click on a hyperlink a secondary pop-window will open. In that pop-up window there will be 'N' number of records arranged in with paging option in datagrid table. Each rows contains two columns, one is text and the other is a radio button. I will pass the first column value and based in it the tool have to select the corresponding radio button in that row. Please someone help me how to handle this as am new to QTP.

2 Answers   CTS,


HI, pls help me on this, iam not able to capture getcelldata value in javatable... msgbox javawindow("").javatable("").getcelldata(3,3) but it diaplays empty...

0 Answers  


When ‘option explicit’ keyword is used in qtp?

0 Answers  


OPening of notedpad in QTP to write and execute the coding?

2 Answers  


WHAT ARE THE DISADVANTAGES OF SHARED REPOSITORY?

9 Answers   BirlaSoft,






hi, In A Table there are some columns and dynamic rows and in each row in first column there is a link with name. upon clicking on that link it will show some details. write the vbscript to check that link without descriptive programming?

2 Answers   HealthAsyst,


how to check URL using QTP? write vb script with descriptive programm only?

1 Answers   Syntel,


what properties do use to identify a browser and page while using descriptive programming?

3 Answers   TCS,


What is the use of environment variables?

1 Answers  


How to open a new test using quicktest professional?

0 Answers  


What’s the basic concept of QTP?

1 Answers  


What is an other way of "Wait" statement in QTP I dont want to use wait("Some number"). Can any one tell this please..........

10 Answers   ADP, AZTEC,


Categories