While exporting a huge data to excel it consumes more than 1GB memory (RAM) on my machine. And finally I gets "Out of memory exception".
Is there any way by which we can release some memory while exporting to excel?
Will ExportCache.Clear() solve the problem? If yes, how can we call it because ExportCache is a private property in DataPresenterExcelExporter class?
I am already done with setting ExportOptions. Is there any other way to get it done?
Any help is very much appreciated.
Hi,
I'm looking into this for you and I’ll post back here as soon as I have more information.
Would you be able to provide a description of the data that you are exporting, how many columns and rows or perhaps a sample that demonstrates the data that you are creating? If you’re using a viewmodel to load the grid and the code to generate the data, that would be very helpful.
I have built my own sample but it doesn’t generate sufficient data to match your description.