I am using POI V3.5, and was creating binary .xls files. Now that I understand large export are possible only using xml based .xlsx files approach, thanks for you help.
I have another question, for an export more than 65,535 records, how to instruct xml to open up in a separate sheet instead of not showing the rest of the records? Thanks, Santosh -----Original Message----- From: MSB [mailto:[email protected]] Sent: Friday, October 23, 2009 7:57 PM To: [email protected] Subject: Re: Any solution to eliminate out of memory error for large export to excel apart from increasing the heap size. 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/po i/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.-tp26022706p26 027366.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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
