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

By using QTP can we record any log files written by the application which is in execution?

1736


hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com

1865


what is the difference between built-i function and In-built function?

1915


Where is the Bitmap checkpoint information stored?

2015


How many types of run modes are there in qtp?

823


Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("» County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

1570


how to test use the quality control .how to verify the image verification

2850


What are the types of properties that quick test learns while recording?

800


Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.

2701


I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all

1759


what is the difference between IE & Netscape in web testing on a log in page

2050


what are the issues we will get when there is migration from QTP 8.2 to QTP 10.0? Is there any problem in executing scripts of 8.2 on 10.0?

1701


What is an optional step in qtp ?

883


Explain how you can replace string in qtp?

843


what type of framework u r using in ur organization

1864