You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by "Suarez, David" <da...@medcohealth.com> on 2002/12/31 20:56:08 UTC

large spreadsheet with small memory footprint

            I need to create a large spreadsheet but I am limited to amount
of memory allocated to JVM.  

 

            If I execute the application with java setting of "-Xms128M
-Xmx512M", it successfully creates 60,000 row spreadsheet with 20 columns,
total spreadsheet file is 20meg.  The Unix administrator is restricting the
JVM to maximum of 256meg of heapsize.  I only need to write(create) the
spreadsheet(reading is not a requirement).  

      So how do I create a large spreadsheet with small memory footprint ?