WebExcelExporter and large datasets

5368

Rob Hudson posted over 13 years ago

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.

15979

Alex E posted over 13 years ago in reply to Rob Hudson

Hello Rob,

Let me know if you need further information about this feature.
Cancel
Reply

Cancel
5368

Offline Rob Hudson posted over 13 years ago in reply to Alex E

Thank you Alex, I did use the Feature Request page.

I like to post feature ideas in the forums to generate conversation about how some features might work, as well as to get feedback on whether an existing workaround exists to satisfy my requirement.

Thanks,

-Rob
Cancel
Reply

Cancel
15979

Alex E posted over 13 years ago

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.
Cancel
Reply

Cancel