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 the difference between Client/Server application and Web application ?

2 Answers   ArisGlobal,


how do close the task manager through QTP?

2 Answers  


Can objects recognised without repository?

5 Answers  


what is the difference between ClassName and class in QTP?

3 Answers  


What is meant by Step Generator in Qtp How is it used? pls gimme in detail

7 Answers   AppLabs,






we have one text box and one list box(list box appear in same page or another page) what ever the text enter in text box that must be displyed in list box as first one. for example if we enter 10 in text box that is the 1st item in list box . after that we enter 11 then 11 is the 1st item and 10 is 2nd item. the maximum limit of list box is 10 items. if we enter 11th item the 10th item is deleted and llth one is add as 1st one and 9th one goes to 10th position part2:maore than the answer for this question i want the the reason why testers go for this kind of risk.what is the use of we testers having these kind of attempts.is that not the problem with the developer .pls answer .real time users of tools.in which way these solutions help to test with r without affecting the developed souce code.

3 Answers  


What is synchronization? What are the ways you can synchronize?

0 Answers  


what are the main differences between keyword driven frame work and data driven frame work?

1 Answers   UHG,


how to associate object repository during runtime in qtp

1 Answers   Deloitte,


How can i Save the snapshots in a specified folders using Scripting in QTP?

1 Answers  


There is web page with the webtable,this contains some data, how do you manipulate the data.

2 Answers   Tech Mahindra,


How to capture data from images in QTP and produce them in Excel sheet ? please ans...

3 Answers   Sapient,


Categories