Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
The DataTable.ExportSheet operation failed. Invalid file.
#1
Not Solved
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.
Reply


Messages In This Thread
The DataTable.ExportSheet operation failed. Invalid file. - by Niraj - 05-14-2014, 08:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Invalid file error importing xls file Makhado 0 1,197 10-04-2018, 04:33 PM
Last Post: Makhado
  How to append date to xls file using qtp datatable methods? yona34 1 1,469 05-04-2018, 08:56 PM
Last Post: Ankur
  Excel operation - to find usedrange of rows & col pooja 1 9,394 02-19-2015, 04:06 AM
Last Post: supputuri
  Invalid File error importing a spreadsheet but only on a VM msacks 1 2,580 10-19-2014, 09:04 PM
Last Post: supputuri
  Capturing the exact time when an operation is performed. Dilliz 2 2,847 01-09-2014, 03:30 PM
Last Post: Dilliz

Forum Jump:


Users browsing this thread: 1 Guest(s)