Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
5368
WebExcelExporter and large datasets
posted

I could really use some enhancements to the WebExcelExporter. It does not work well with large datasets.

Right now, the WebExcelExporter requires that the entire dataset be loaded into memory.  Further, it requires the additional overhead of being bound to a WebDataGrid.  Attempting to export large amounts of data results in "Out of Memory" errors and timeouts.

  • It would help me out a lot if the WebExcelExporter.Export() could have an overload WebExcelExporter.Export(sqlDataReader). With that, the data can be streamed to the exporter and straight to the response output stream without having to be attached to a WebDataGrid or stored in memory. 
  • If the WebExcelExporter could stream the document as it is being built, instead of building the document and then writing it to the output stream, that would be even better for memory consumption.
Parents Reply Children
No Data