Out of memory writing a 50k+ file

[Hastur78]

Hello,

During the process of writing a large xlsx file, with more than 50k rows, an out of memory happens.
Is there any way to reduce the memory consumption during the file writing?

Thank you

Antonio

[Tolls]

This is where I question the wisdom of a 50000 row spreadsheet...
:)

POI (and pretty much every Java-Excel framework) needs to hold the workbook in memory, and this is the cause of the problem. There's not a great deal you can do about it. If it's only crashing on the write have you considered giving it a bit more memory? SOunds like you are right on the edge of what it needs to do its job.

Of course that's not terribly scalable, but then neither is Excel.