Yegor, Thanks for the prompt reply. I had already seen the BigGridDemo.
I will try out your BigGridDemo. But the question remains. Are there any plans to fix the memory usage for the EXCEL 2007. The memory requirement seems to be unbelievably high. Regards /sanjay On Fri, Jul 17, 2009 at 7:34 PM, Yegor Kozlov <[email protected]> wrote: > Use direct streaming in XML. A sample implementation can be found at > > > http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java > > It's not a ready-to-use API, rather a proof of the concept. To use more > advanced features (merged cells, custom height or width of rows and cells, > conditional formats, etc.) you will need to study the SpreadsheetML > documentation and enhance the demo. > > Yegor > > > We have been using POI for EXCEL generation for a number of years >> successfully. >> >> Recently we started using the EXCEL2007 (OOXML) generation capabilities of >> POI 3.5. >> The reason we wanted the OOXML capabilities was to generate excel reports >> with more than 64K records. >> >> As soon as we started using the OOXML/POI 3.5beta5 version we started >> having >> enormous memory issues that pretty much makes POI unusable for our >> scenarios. >> >> We regularly generate reports with 20K -50k records and this was handled >> easily with the excel format. >> >> The OOXML format with poi uses humongous amounts of memory even for modest >> number of records. >> >> For example we generated a report with 14K records and unless we allocated >> 1.2GB of heap space to the Java VM the report could not complete. The >> usual >> error is the Java VM crashes with a not enough heap space error. >> >> I would appreciate if anybody could advise us on how to avoid this memory >> situation. >> >> Also why does POI 3.5 keep everything in memory? >> >> Are there any plans to rework POI 3.5 to better manage generation of large >> excel 2007 worksheets? >> >> >> Thanks and regards >> >> /Sanjay >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
