The jvm heap size is 1024. So I cannot improve much. How can I use CSV? I didn't use before and I don't know how I can use it.
Nick Burch wrote: > > On Wed, 19 Dec 2007, peri wrote: >> In the program I can only write 12000 records to the excell file. After >> 12000 records I get out of memory errors. > > I'd suggest either writing out as a csv (much less memory hungry), or > increasing your java heap size. > > Unfortunately, building up excel files requires lots of memory, and > there's no way to do a streaming write (the file format isn't really > designed for that) > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/How-can-I-solve-the-outof-memory-error-on-excell-file-which-is-created-hssfworkbook-tp14412958p14420276.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]
