Error While Exporting Excel

[Ankesh]

I am getting attached excel error in the script when I export the QTP datatable to excel using - DataTable.Export statement.

[Ankesh]

Any solution for the above issue? I am still facing this problem?

Any help would be appreciated?

Regards,
Ankesh

[parminderdhiman84]

have you tried exporting the datatable manually from run time datatable? Could you please attach a copy of the exported datatable.

[Ankesh]

Hi Parminder,

Thanks for looking into this.

I tried exporting the run-time datatable, but i couldnt as i got the error "A general error occured while exporting the sheet."

---

I am attaching the error screenshot.

[parminderdhiman84]

Hi Ankesh,

So now we can say that there is nothing wrong with the script. I only see two possibilities of the error:

1) There might be something wrong with the data that you are trying to export
2) The version of excel and the QTP might not be compatible(did you verify the export with some sample data to excel, if that is working fine then it should not be the case)

Regards,
Parminder

[ravi.gajul]

Hi Ankesh,
Check if this helps

http://testing-qtp-me.blogspot.com/2010/...-when.html

Regards,
Ravi

[Ankesh]

Thanks Parminder and Ravi for ur support.

I will have a look at it and will update u the status.

Regards,
Ankesh

[Ankesh]

Hi Ravi,

The solution provided in the Link worked for me.
Thanks a lot for helping me out.

Regards,
Ankesh

[ravi.gajul]

And the credit goes to jonty......thank you Jonty, the author of the blog

http://testing-qtp-me.blogspot.com/2010/...-when.html