Can you import and export data from XLS and how?

Question Posted / mythreyi_bh

4 Answers
7956 Views
I also Faced
E-Mail Answers

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 type of VB script u had done in expert view?

1 Answers

How many ways to configure the application in QTP,Explain

2 Answers CTS,

How to delete an object from the object repository?

0 Answers

Hi, is it possible for recording shortcut key during record session? The application on which I am working is web based application. This application has several shortcut key associated with menu option. I have succesfully recorded all menu option but unable to record shortcut key.

1 Answers

If 2 gmail browsers are opened in our system, how to enter the mail id and password into second browser by using discriptive program?

7 Answers Mphasis,

What does "Dynamic change on web pages" means.As per my knowledge, this comes in "Complete" level of Active screen capture levels, where it says, "Also dynamic changes on web changes are saved.so i want to know what type of dynamic changes are made and is this dyanmic changes efftes only on web application or any other?

0 Answers EDS,

does automation replace manual testing?

2 Answers

What is use of object spy?

0 Answers

I used Child objects to get the count of the no of weblist present in the page.now i need to select the item in the weblist..Please send me full code

1 Answers

What is test object model in QTP?

1 Answers Crea,

What kind of errors can b handled in QTP in real time scenario?

1 Answers

How software tester can use constants and variables in scripts?

0 Answers

For more QTP Interview Questions Click Here