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

In a Web appl, on a page, there are student names & details listed.On clicking sort button,details are sorted on Names.How do u verify htat sorting is done by using QTP?

1 Answers   IBM,


Which object repository we use in real time and can we merge 2 object repostiory and how?

6 Answers   HCL, Satyam,


What is the difference between run time object and test object in QTP?

0 Answers  


How to use Environment parameterization in QTP? Explain with an example.

2 Answers  


How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

0 Answers   CFC, iton,


can any one give me the doccument how to test aproject developed in java language in qtp can here can we use the general vb scripting or we have to use java script here if we have to ese the java script here can any one send me the manual for it means how to write descriptive programming for it thanks in advance

1 Answers  


I have a drop down box to show selected number of records in result page.It contains 4 items like 10, 25,50 and 100. when i was recordes script for seelcting each item and checking selecting number of records in the result page( it is in the same page in the table format)it is generating a new page with same controls( objects) in the OR. how to avaid these in OR? is it possible to write DP for only these lines?, remaining(remaingin lines of code) objects i want use from OR only. One more problemis if change ( add /remove properties of an OBJECT in OR , my ( recorded )application is not running.

5 Answers   Virtusa,


What are the Test design techniques you uses in ur project?

0 Answers   Accenture,


What is keyword driven framework, what is "key" in It.

2 Answers   IBM,


how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief

0 Answers   HCL,


i need the licence key for QTP V9.5 can anyone help me on getting this?

140 Answers  


In automation testing Can we retest virtual object in the application after getting new version from the developers, is there any property will change for that object or it won't.?

1 Answers   Siemens,


Categories