What is your java command line exactly? -Xms256m -Xmx1500m Also, is your xls formatted or plain? Formatted with alternate rows having colors , 2 fields having numericalformat , 2 having dates format and 2 having currency format How many columns on each row? 15 columns
David Fisher wrote: > > Did you try 1500M? If you did 1500 then that is thousands and equal > to1.5 lakh. Not enough is it? > > Regards, > Dave > > On Jul 11, 2008, at 12:16 AM, suriz4u wrote: > >> >> 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] >> > > > --------------------------------------------------------------------- > 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-tp18381577p18397108.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]
