+- 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: Error While Exporting Excel (/Thread-Error-While-Exporting-Excel)
Error While Exporting Excel - Ankesh - 10-21-2011
I am getting attached excel error in the script when I export the QTP datatable to excel using - DataTable.Export statement.
RE: Error While Exporting Excel - Ankesh - 10-24-2011
Any solution for the above issue? I am still facing this problem?
Any help would be appreciated?
Regards,
Ankesh
RE: Error While Exporting Excel - parminderdhiman84 - 10-24-2011
have you tried exporting the datatable manually from run time datatable? Could you please attach a copy of the exported datatable.
RE: Error While Exporting Excel - Ankesh - 10-24-2011
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.
RE: Error While Exporting Excel - parminderdhiman84 - 10-28-2011
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
RE: Error While Exporting Excel - ravi.gajul - 10-28-2011
Hi Ankesh,
Check if this helps
http://testing-qtp-me.blogspot.com/2010/06/qtp-kb-2-general-error-when.html
Regards,
Ravi
RE: Error While Exporting Excel - Ankesh - 10-28-2011
Thanks Parminder and Ravi for ur support.
I will have a look at it and will update u the status.
Regards,
Ankesh
RE: Error While Exporting Excel - Ankesh - 11-03-2011
Hi Ravi,
The solution provided in the Link worked for me.
Thanks a lot for helping me out.
Regards,
Ankesh
RE: Error While Exporting Excel - ravi.gajul - 11-03-2011
And the credit goes to jonty......thank you Jonty, the author of the blog
http://testing-qtp-me.blogspot.com/2010/...-when.html