Have you checked out the HEAD? Andy put out the performance branch there that reduces memory usage as well increasing performance. It's a little broken right now but if it works for you...

Cocoon uses the usermodel at the end of the day :)

danny

Robert Lowe wrote:

I'm currently using POI to generate some fairly large Excel files (30,000+
rows), using the org.apache.poi.hssf.usermodel package.

While this works okay, it (i) requires lots of heap space (512 MB seems to
do it), and (ii) takes several minutes.

Is there any way to generate Excel files using an event-based API, and hence
avoid buffering the entire document in memory? I know there's an event-based
API for reading docs, but haven't come across anyhting similar for writing.

Should I be looking at Cocoon?

Best regards,

Robert Lowe
http://RMLowe.com/



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to