Yeah its 5lakh rows.I increased my heap size to 1500 as i have only 2gb ram.Then also iam getting out of memory error.Is there any way to get rid of this problem with POI ? ,if there is any solution please help me.Or is it advisable to use other API's .If it is advisable can u please suggest me which api is better to use and why?.Please give me detailed explanation. Any suggestions would help me a lot.........
Thanks Suresh Gaddam apachemail wrote: > > I believe you are correct about 500,000. That many rows is most likely > going to take much more memory than 1MB. > > -----Original Message----- > From: Kendall Coolidge <[EMAIL PROTECTED]> > Sent: Thursday, July 10, 2008 10:20 AM > To: POI Users List <[email protected]> > Subject: RE: Its urgent===Please help > > How many rows are you trying to write? Does 5 lakh mean 500,000? > > > -----Original Message----- > From: suriz4u [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2008 9:33 AM > To: [email protected] > Subject: Re: Its urgent===Please help > > > I checked with 1024 memory .But i am getting error if i have 5 lakh rows > of > data.If rows are less iam getting no problem.Other wise iam getting out > of > memory.Can i get the solution please..?? > > > > Nick Burch wrote: >> >> On Thu, 10 Jul 2008, suriz4u wrote: >>> In my application iam using POI to generate excel sheet.Iam writing >>> work >>> book into ByteArrayOutputStream after processing the rows.But if i > have 5 >>> lakh rows to write.Iam getting out of memory error. > > > [The entire original message is not included] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Its-urgent%3D%3D%3DPlease--help-tp18381577p18396926.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]
