Excel Export Out of Memory

[jmaglio]

Hi
I get an OutOfMemoryError when exporting a large (64MB)spreadsheet. The app is deployed on WAS.  Some of the jxl.WorkbookSettings methods reference WAS.

Are jxl.WorkbookSettings methods: setArrayGrowSize() and setInitialFileSize()
exposed via the Seam <e:workbook> tag?

I tried to use the arrayGrowSize and initialFileSize attributes, but they did not have any impact.
Increasing the heap size on WAS solved the issue but I would like to try and solve it with e:workbook tags if possible.

Thanks
Joe

[nickarls]

They should be (check the docs so I don't have to ;-))

But in the end it's heap size that counts for 99% of the cases. I've managed to produce 200Mb+ files on 32b JVMs (with around 1400Mb heap). For humongous sheets, I recommend 64bit OS/JVM:s so you can use more memory.