The DataTable.ExportSheet operation failed. Invalid file.

[Niraj]

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.

[sampath]

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.

[babu123]

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.