search

jameskleeh / groovy-excel-builder

A Groovy DSL for Building Excel Files
Apache License 2.0
46 stars 14 forks source link

Consider using SXSSF #21

Closed tobia closed 5 years ago

tobia commented 6 years ago

SXSSF (Streaming XSSF) is the API variant that avoids storing the entire workbook in the Java heap memory as it's being built. This is important for most data extraction usages, in the same way as Groovy supports the Sql#eachRow() method as a streaming, memory-conserving option over Sql#rows().

I would suggest considering whether to use SXSSF by default, or at least toggled by an option.

See the HOWTO here http://poi.apache.org/spreadsheet/how-to.html#sxssf and various topics such as https://stackoverflow.com/questions/47851078/

jameskleeh commented 6 years ago

@tobia I wasn't aware this was an option. Thanks for bringing it to my attention. I'll look into it

jameskleeh commented 5 years ago

Done in 1.0.0 snapshot - please test