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,216 10-04-2018, 04:33 PM
Last Post: Makhado
  How to append date to xls file using qtp datatable methods? yona34 1 1,492 05-04-2018, 08:56 PM
Last Post: Ankur
  Excel operation - to find usedrange of rows & col pooja 1 9,420 02-19-2015, 04:06 AM
Last Post: supputuri
  Invalid File error importing a spreadsheet but only on a VM msacks 1 2,604 10-19-2014, 09:04 PM
Last Post: supputuri
  Capturing the exact time when an operation is performed. Dilliz 2 2,855 01-09-2014, 03:30 PM
Last Post: Dilliz

Forum Jump:


Users browsing this thread: 1 Guest(s)