On Tue, 21 Feb 2012, Oleg Rempel wrote:
Oleg Rempel <Rempel.Oleg <at> managetopia.com> writes:
I am working with the apache.poi developments for MS Excel
Input/Output. After changing from the HSSFWorkbook to the XSSFWorkbook,
requires at my java program more MBs of RAM. 1,5 GB in place of 260 MB.
Sounds about right. The .xlsx format needs more memory to process
Can this be controlled?
Are you reading or writing? If reading, you can use sax based parsing for
a streaming, low memory way to read a .xlsx file. For writing, SXSSF lets
you write in chunks, minimising the amount of stuff that has to be kept in
memory. See the website for details on both
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
