I am trying to export an grid using the Excel Exporter. The first time works just fine but after that I get the following error:
An export operation is currently in progress. A new export operation cannot begin until the current operation completes.
The title of the error is Infragistics4.Win.UltraWinGrid.ExcelExport.v11.2
This is only occurring at one particular customers site. I cannot reproduce in my office.
Does anyone have any ideas?
Well,
I narrowed the issue down. What is happening is the user is exporting to excel the first time. They are leaving Excel open with the default workbook name. When they try to export a 2nd time they get an error thrown from mscorlib that the file is in use which would be correct. At that point if they attempt to export again you will get the error thrown from the excel exporter that an operation is currently in progress. Even if you close all excel workbooks the excelexporter is in a state where it thinks it is still exporting.
Is there a way to reset the excelExporter?
Hi Roger,
This sounds like a bug in the exporter to me. My first recommendation is that you try getting the latest service release. The issue is most likely already fixed.
How to get the latest service release - Infragistics Community
Mike,
I just tested with 2011.2 SR 2135 and I still see the issue. Once the file in use error occurs the only way you can export a grid is to exit the application and then startup the app.
Hello,
I created the following case for you: 'CAS-111004-P1Y9T6' and will update you through it.
Okay, Thank You.
I'm facing the same issue while exporting an Excel.
If I export an excel and then keep the exported excel open and try to export again, I get the exception:
The process cannot access the file 'xyz.xls' because it is being used by another process.
If I close the file and try to export again, I get the following exception :
Do we have any fix or workaround for this ?
They have fixed it in the following service releases. I am on an older version so I had to write a workaround but if you are using one of the releases mentioned below you should be able to install SR and have fix.
Issue "134236: The exporting process raises "System.InvalidOperationException" exception." has been addressed in service release versions 2013.1, WinForms_12.2.20122.2052, WinForms_12.1.20121.2118.
Roger,
Thanks for your reply. We are using an older version.
So I used a workaround and added datetime stamp to the file name being exported.
Regards,
Monica