This is a migrated thread and some comments may be shown as answers.

Export To Excel Never completes

2 Answers 25 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Eric Klein
Top achievements
Rank 1
Eric Klein asked on 21 Aug 2013, 04:29 PM
I have a grid that has the export to excel functionality.  When the grid has a small number of records it works, but in some cases I need to be able to export large number of records.  One instance is 122,103 records. 
I have the MaxRows set for 1048576, so it should fit on one sheet, but when it hits this line of code.
I am using ExportToExcelML.
excelExporter.RunExport(fileName);

It seems to become unresponsive.  I have let the application run for up to 10 min with the export never being created.

Also right now I simply change the cursor to a waitcursor during this time, is there anyway to show progress of the export?

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 1
answered on 03 Sep 2013, 03:26 PM
Hi Eric,

Please check the following demo on Export to ExcelML .please have a look at this forum which discusses about showing the progress bar during export.

Thanks,
Princy
0
Eric Klein
Top achievements
Rank 1
answered on 03 Sep 2013, 04:21 PM
Thanks for the response, but I have just noticed that this was posted in the asp.net Ajax section, this was meant to be in the winforms.  Is there a solution in winforms for this?
Tags
Grid
Asked by
Eric Klein
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 1
Eric Klein
Top achievements
Rank 1
Share this question
or