search

FlowingCode / GridExporterAddon

Apache License 2.0
10 stars 9 forks source link

Explore Integration of SXSSFWorkbook for Improved Export Performance #94

Open brunoagretti opened 7 months ago

brunoagretti commented 7 months ago

It would be greate to investigate potential implementation of the SXSSFWorkbook Workbook from Apache POI to enhance the performance of data export.

mlopezFC commented 7 months ago

I investigated this issue. It might be possible, but the problem is that one of the key features is the possibility of defining the styles of the cells of the rows in the template. With SXSSFWorkbook the template will only be usefull for the cells before the headers and rows, and the output will not be styled. One idea would be to generate an alternate stream factory that would ignore styling and would be suitable for big datasets.