Re: POI large file

Darren,

I hadn't heard that. Thanks.

Does this happen automatically if you are using poi3.8 or are there
special steps you need to take?
(after i read your reply i googled sxssf [below])

John

<snip>
Since 3.8-beta3, POI provides a low-memory footprint SXSSF API built on
top of XSSF.

SXSSF is an API-compatible streaming extension of XSSF to be used when
very large spreadsheets have to be produced, and heap space is limited.
SXSSF achieves its low memory footprint by limiting access to the rows
that are within a sliding window, while XSSF gives access to all rows in
the document. Older rows that are no longer in the window become
inaccessible, as they are written to the disk.
</snip>

I find generating spreadsheets with the SXSSF streaming model in POI

works

a lot better. It nearly eliminates the heap size issue. The downside

is

that you need to build the spreadsheet from the top down. Since that
describes 97% of the work we do, it works well for us.

<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.