Micro Focus QTP (UFT) Forums
The DataTable.ExportSheet operation failed. Invalid file. - Printable Version

+- 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: The DataTable.ExportSheet operation failed. Invalid file. (/Thread-The-DataTable-ExportSheet-operation-failed-Invalid-file)



The DataTable.ExportSheet operation failed. Invalid file. - Niraj - 05-14-2014

Hello,

I am getting this error - 'The DataTable.ExportSheet operation failed. Invalid file.' as soon as I upgraded to QTP 11.0. Currently i am using UFT 11.52 and MS-Excel '.xls' format for all import and export datasheet/test case files. It is keyword drive framework

This is not a consistent error and it comes after some test cases executed. let's assume i have 100 test cases. After running 35 test cases i received this error. 'Retry' or 'skip' does not help here and i have to STOP the regression and start it once again. Once i stop and start the regression from test case 36 onward, then i do not receive any exportsheet error.

I am not able to find out the actual problem. It could be with excel or could be with memory allocation.

Can anyone please help me on this.


RE: The DataTable.ExportSheet operation failed. Insufficient memory. - sampath - 04-29-2015

Hi

using UFT 12

I have been getting "The DataTable.ExportSheet operation failed. Insufficient memory.
" sporadically , even though i have sufficient memory in my machine.

this is what i am trying to do

1. Create Run time DT Sheets , fill with output data
2. At the end of each iteration export the DT sheet to excel

Please help.


RE: The DataTable.ExportSheet operation failed. Invalid file. - babu123 - 05-05-2015

we also got same issue some time back.Turn around is..... Change the path of the saving file location on the drive(use ur local C drive) or u can use datatable.Export only method which exports whole workbook.