data table

[ksrikanth2k9]

Hi Sia Sharma,

Try using Datatable.import "D:\Sheet.xls"

hope it works...

Srikanth

[Shridevi.Salagare]

Is the sheet u import .xls format only.
Please check that once..
The code looks fine.

[sia sharma]

@ 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

[SIBICA]

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

[ksrikanth2k9]

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

[ksrikanth2k9]

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?

[sia sharma]

a screen shot

---

The Export operation is working fine ...

Only import is giving error...

What does it mean not supoorted by formula one?

[Ankesh]

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.

[sia sharma]

i m not using any formula ...
and i m also not using any formating...

[Ankesh]

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