May I ask which version of the Excel file format you are targetting? Are you trying to create binary .xls files or xml based .xlsx files? If the latter then you could take a look at the http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java proof that Yegor created. It is only intended to demonstrate a technique and must not be thought of as a complete application however.
If, however, you are targetting the binary file format then I am afraid that the news is not too good. Owing to the file format - it consists of a series of linked lists - it is not possible to write the file out in chunks. Yours Mark B Dronamraju, Santosh B (GE Indust, ConsInd) wrote: > > Hi everyone, > > > > For large excel exports, I get out of memory error. Is there any way to > write directly to physical file record by record instead of using heap > and then writing the whole data to file system at the end? > > > > Because increasing heap size is not working even if I use 1024 MB. As in > our application we have large and number of export to excel. > > > > Thanks, > > Santosh > > > > > -- View this message in context: http://www.nabble.com/Any-solution-to-eliminate-out-of-memory-error-for-large-export-to-excel-apart-from-increasing-the-heap-size.-tp26022706p26027366.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
