Eric Klein
Top achievements
Rank 1
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.
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?
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
0
Princy
Top achievements
Rank 2
Rank 2
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
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
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?