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:[EMAIL PROTECTED] > Gesendet am: Montag, 20. Juni 2005 16:34 > An: [email protected] > 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: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
