+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: data table (/Thread-data-table)
RE: data table - ksrikanth2k9 - 09-11-2012
Hi Sia Sharma,
Try using Datatable.import "D:\Sheet.xls"
hope it works...
Srikanth
RE: data table - Shridevi.Salagare - 09-11-2012
Is the sheet u import .xls format only.
Please check that once..
The code looks fine.
RE: data table - sia sharma - 09-11-2012
@ SIBICA : The datasheet is there in the D drive
and I have already shared a screen shot.
@shredevi.salagare : yes its in the .xls format
Thanks,
sia
RE: data table - SIBICA - 09-11-2012
Exactly,
Again if you are getting errors can you please share the screen shots of error and the excel sheet present in d drive.
Regards,
Sibi C A
RE: data table - ksrikanth2k9 - 09-11-2012
hi,
We need not to pass any arguements when using Datatable.import command....
It can be done with the simple command Datatable.import "D:\Sheet.xls"
make sure the file extension is xls not xlsx.And the file is not opened or in access of the other program.
Srikanth
RE: data table - ksrikanth2k9 - 09-11-2012
I have a doubt from your screenshot..your excel sheet name is "sheet" or "sheet.xls"?? while saving the file how did u save it?
RE: data table - sia sharma - 09-11-2012
a screen shot
The Export operation is working fine ...
Only import is giving error...
What does it mean not supoorted by formula one?
RE: data table - Ankesh - 09-11-2012
Have you used any formula in the file that you are importing?? Please note you can not import a formatted file to QTP datatable. Please remove the formulas/Formatting, if any, and try again.
RE: data table - sia sharma - 09-11-2012
i m not using any formula ...
and i m also not using any formating...
RE: data table - Ankesh - 09-11-2012
One query, are you having MS excel installed on your system??? Screenshot shows Open office. May be there is the issue. I am not sure though. You can probably check on the system which has excel installed.
Regards,
Ankesh