Can you import and export data from XLS and how?

Answers were Sorted based on User's Feedback



Can you import and export data from XLS and how?..

Answer / uday kumar_anem

We can import or export the data from Excel sheet in 2 ways.
1. by using Datatable.import("ExcelFile")
Datatable.export("ExcelFile")
2 Place your mouse over datatable in QTP and right click ->
File -> Import File /Export

Is This Answer Correct ?    1 Yes 0 No

Can you import and export data from XLS and how?..

Answer / dixit

her i want to add some thing
if you want to import particular sheet then you can use
ImportSheet method

DataTabe.ImportSheet("path of Excel",Source Sheet,Dest
Sheet)

Is This Answer Correct ?    1 Yes 0 No

Can you import and export data from XLS and how?..

Answer / ramu@sunnys

yes,we use datatable.import for import data and
datatable.export for export the data

Is This Answer Correct ?    0 Yes 1 No

Can you import and export data from XLS and how?..

Answer / ramu@sunnys

yes,we use datatable.import for import data and
datatable.export for export the data

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More QTP Interview Questions

Explain about the Test Fusion Report of QTP?

1 Answers  


Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com

0 Answers   TechSoft,


hi testers,one script has three actions , at the of running three actions are running , how to set run only perticular action and what is the use of split the action? when it will be useful?

3 Answers   Syntel,


what is the difference between QTP 8.0 & 9.0?

4 Answers  


How many check points are there in QTP and what are they?

5 Answers  






object types is used for what?

1 Answers  


How to use custom checkpoints in QuickTest Professional?

1 Answers   TCS,


Hey friends i m facing a problem when i m running my script in qtp it waits for about 5-10 secs before starting execution why it is so can any one solve my problem .Previously it was running fine

1 Answers  


Hi, i have a string like "INDIA". I need to display this string vertically in Msgbox?

3 Answers  


How to find array size in qtp?

0 Answers  


Write code for ,We have a web table with rows and columns like EmpID EName Action 1 ABC Edit Delete 2 XYZ Edit Delete 3 PQR Edit Delete In the above Table the last column has two links we have to click first link based up on EmpID =2

2 Answers  


Describe how Smart Identification is used

0 Answers  


Categories