Forums Ultimate UI for ASP.NET Web Forms
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
Close
Rob Hudson
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
No Data
Reply
  • 15979
    posted

    Hello Rob,

    The described by you functionality is not currently supported in “WebExcelExporter” control.

    However, this functionality can be considered as feature request and if you like to see this functionality in future releases, feel free to submit feature request on the following link - http://devcenter.infragistics.com/Protected/RequestFeature.aspx

    If you cannot submit Feature Request your own I can do this for you.

    Let me know if you need further assistance with this question.

Children