Can you import and export data from XLS and how?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji

1847


What is difference in global and action sheet in qtp?

838


Hi, While recording a Jave based web application, its recording all my actions and the objects.And I have 5 WebEdit objects on the page and all are recorded. But while execution, at the 2 WebEdit object, its entering the value into the object (Its making a call to the AJAX, matching the value), when the control get out of this object the value is erased or cleared. Could anyone please help. I have recoreded 5 more scenarios where WebEdit is in the picture on different webpages and all are working fine. Here is my Script: Browser("Sign In").Page("Matching Workbench_3").WebEdit ("locationLookup").Set "0320 - SEATTLE-KM" Browser("Sign In").Page("Matching Workbench_3").WebEdit ("supplierNameLookup").Set "TRAMMO PETROLEUM INC" *** SupplierNameLookup is the object, which is haing an issue. And also I was using the SendString function, but it didnt work.

2004


How do Parameterization and Data-Driving relate to each other in QTP?

823


what is test scheduleling?

2260


Is it possible to split an action? How?

861


How do client side image and server side image work?

1608


Explain the types of object repository?

749


How to create scenario selector

1714


Can anybody post some real time scenario in qtp? please its very urgent.

2040


How do you synchronization point through DP?

804


Where we can use the analog mode and where we can use the low – level mode?

790


How to use output values in qtp ?

735


Explain how Selenium is different from UFT?

894


can the activities of test case design be automated?

1658