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
Yuriy Galanter
1290
Version, Memory and Groups
posted

Several questions about WebExcelExporter

  1. In which version of NetAdvantage was it introduced?
  2. While generating Excel file - does it build it in memory and then sends to browser? If so - how it deals with large datasets (1000s of rows) ?
  3. If exporting a flat WebDataGrid - is there a way to introduce Excel Outlines (groups) programmaticaly during export?

Thanks!

  • 24671
    posted

    Hi,

    1) it was introduced in 10.2

    2) yes,  it builds it into the memory. There are several ways to improve performance. The first is to disable exporting of styles - this introduces some overhead that could be significant when dealing with very big data sets. The second one is to export only visible data vs. exporting the whole data set. So let's say you can have paging enabled, but you can still export all of the contents in the data source to which the grid is bound. You can also programatically limit the number of rows exported using the RowExporting / RowExported events. 

    3) This is a more complex scenario that can be handled using the server-side events exposed in the control - RowExporting / RowExported, CellExporting / CellExported. You can contact Development support for a step by step resolution of your scenario.

    Hope it helps,

    Angel