QTP Forums

I am not able to import the data from external .xlsx file using importsheer method....below is the code 'm using

Datatable.addsheet(mydata)
datatable.importsheet "C:\myfile.xlsx",mydata,mydata
I made sure that the myfile has the first sheet named as mydata.
But when running the code, the data is not getting imported.
Can anyone help me with this

Hi Maddy,

Please check whether your excel file is save in 97-2003 format or not if you are using MS-2007 and saved with 2007 format then it will not able to import the data from excel to datatable.

Please let me know for fourther clarification

Regards,
Venkat.Batchu

Thanks Venkat for your clarification. It work's now.

(08-18-2010 05:40 PM)venkatbatchu Wrote: [ -> ]Hi Maddy,

Please check whether your excel file is save in 97-2003 format or not if you are using MS-2007 and saved with 2007 format then it will not able to import the data from excel to datatable.

Please let me know for fourther clarification

Regards,
Venkat.Batchu