Just use csv format to write 500000 rows -Ravendra -----Original Message----- From: suriz4u [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2008 10:47 AM To: [email protected] Subject: RE: Its urgent===Please help
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-tp18381577p1839692 6.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] This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
