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

What is User defined function in QTP

6 Answers   Bank Of America,


what is the criteria for choosing test cases for automation? Ex: if you have some 300 test cases, then how many you choose for automation. what is criteria of selecting?

3 Answers   Aricent, Delhi University, TCS,


what time u r using data driven test in ur app"

6 Answers   Accenture, IBM,


Can anybody give the script to addsheet, add column,add values under that column in the rows??

5 Answers   AZTEC,


Add parameters during time in each row in one column

0 Answers  






give me descriptive programing code sample flight application in qtp?

8 Answers   CA, IBM,


how to parameterizing values from an excel sheet in Quick test professional?

1 Answers  


Hi, It is HR question. What are the qualities you like and dislike in your Project Manager?

2 Answers   TCS,


hi i have 4 yrs exp in manual and automation testing using QTP i need sample resumes plz can u send this mail id pbre1980@gmail.com

0 Answers  


What is the ur roles and responsibilities as automation testing engineer?

2 Answers   Atos Origin,


How will you report the bug and explain the defect tracking sheet you handled?

0 Answers   TCS,


Please guide me release notes of Automation once scripts are completed

0 Answers  


Categories