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?