Re: Out Of Memory Problem with large file (60 k rows with 6 colum ns)

[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/
>
>