Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to import and export datatable
#1
Solved: 10 Years, 9 Months ago
Hi all,

I want to import data from my datatable to excel sheet.
i have written like this
datatable.Import "D:\laxmi\Book1.xls"
which is giving error as:
A general error occurred while importing file D:\laxmi\Book1.xls.
Line (1): "datatable.Import "D:\laxmi\Book1.xls"".

please any one can help me out as how to import and export data from datatable.


Thanks in advance
Reply
#2
Solved: 10 Years, 9 Months ago
The imported table must match the test. The column names must match the parameters in the test, and the sheet names must match the action names.

If you import an Excel table containing combo box or list cells, conditional formatting, or other special cell formats, the formats are not imported and the cell is displayed in the Data Table with a fixed value.

below is the code

Datatable.Import <FileName>

Regards,
Ankesh
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Datatable import error Prashanth 7 16,038 11-19-2014, 06:53 PM
Last Post: praveen.g3
  How to import .xlsx file type to QTP qtped 3 6,323 03-27-2014, 01:33 PM
Last Post: Ankur
  Import multiple values from excel into QTP Shaik Ahmed 2 3,254 03-09-2014, 09:17 PM
Last Post: Shaik Ahmed
  Import and read multiple tabs on a datasheet trance07 1 3,086 10-09-2013, 07:29 PM
Last Post: Parke
  Export data shayk1985 3 3,102 05-18-2013, 09:40 AM
Last Post: venugqtp

Forum Jump:


Users browsing this thread: 1 Guest(s)