You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Marx, Stefan ext. MA Fa. Lynx" <St...@rewe.de> on 2005/06/20 18:05:22 UTC
AW: Out Of Memory Problem with large file (60 k rows with 6 colum
ns)
Hi Ajit,
if I may quote myself (experienced exceptions in searching the
mailing list archiv):
due to the wired BIFF format I reached the out-of-memory quite
soon, too.
There are small RAM ressources at my client side and I use the
hack to send a bytestream with tab separation between the fields,
store it with a *.xls extention so Excel open it with the data correct
in columns. Doing it this way I'll lose all formatting but I'm able to
display more the 20.000 records from the DB2 tables. Beyond the
max. of 65.535 recs. Excel display no more lines in a file.
I also mde made an outline to stream the data in blocks or serveral
files, but that solution is to time consuming in my enviroment.
hth, cu Stefan
> -----Ursprüngliche Nachricht-----
> Von: ajit gupta [SMTP:ajitgupta_us@yahoo.com]
> Gesendet am: Montag, 20. Juni 2005 16:34
> An: poi-user@jakarta.apache.org
> Betreff: Out Of Memory Problem with large file (60 k rows with 6
> columns)
>
> Hi !
>
> I receive a java.lang.OutOfMemoryError when I am
> writing particularly large Excel Files (several
> thousand rows of data). Has anyone knows a solution
> to this problem that does not involve adding more
> memory (I have 2Gig on my workstation)or increasing
> heap size.
>
> Solution will be really appreciated.
>
> regards,
>
> Ajit
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Out Of Memory Problem with large file (60 k rows with 6 colum ns)
Posted by Sanjiv Jivan <sa...@gmail.com>.
Stefan,
Could you elaborate on what you're doing (and how you're doing it) when you
say "I use the hack to send a bytestream with tab separation between the
fields, store it with a *.xls extention so Excel open it with the data
correct in columns."
Thanks,
Sanjiv
On 6/20/05, Marx, Stefan ext. MA Fa. Lynx <St...@rewe.de>
wrote:
>
> Hi Ajit,
>
> if I may quote myself (experienced exceptions in searching the
> mailing list archiv):
>
> due to the wired BIFF format I reached the out-of-memory quite
> soon, too.
> There are small RAM ressources at my client side and I use the
> hack to send a bytestream with tab separation between the fields,
> store it with a *.xls extention so Excel open it with the data correct
> in columns. Doing it this way I'll lose all formatting but I'm able to
> display more the 20.000 records from the DB2 tables. Beyond the
> max. of 65.535 recs. Excel display no more lines in a file.
> I also mde made an outline to stream the data in blocks or serveral
> files, but that solution is to time consuming in my enviroment.
>
> hth, cu Stefan
>
> > -----Ursprüngliche Nachricht-----
> > Von: ajit gupta [SMTP:ajitgupta_us@yahoo.com]
> > Gesendet am: Montag, 20. Juni 2005 16:34
> > An: poi-user@jakarta.apache.org
> > Betreff: Out Of Memory Problem with large file (60 k rows with 6
> > columns)
> >
> > Hi !
> >
> > I receive a java.lang.OutOfMemoryError when I am
> > writing particularly large Excel Files (several
> > thousand rows of data). Has anyone knows a solution
> > to this problem that does not involve adding more
> > memory (I have 2Gig on my workstation)or increasing
> > heap size.
> >
> > Solution will be really appreciated.
> >
> > regards,
> >
> > Ajit
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>