Manesh is correct. Just checked with Microsoft and the maximum number of rows in a sheet is 65,536 and the maximum number of columns is 256. Further, it is not possible to increase either of these limits.
If you are trying to write this amount of data onto a single sheet then you will have to re-consider the design and split it across several sheets IMO. --- On Thu, 7/10/08, Mahesh Ganapathy <[EMAIL PROTECTED]> wrote: From: Mahesh Ganapathy <[EMAIL PROTECTED]> Subject: Re: Its urgent===Please help To: "POI Users List" <[email protected]> Date: Thursday, July 10, 2008, 11:28 PM I thought excel could have only 65536 rows per sheet. To start with, can POI write more than 65536 rows to an excel work sheet? If it does not check this limit on excel and you do manage to write 500000 rows, office might not be able to open the document properly. This is assuming that you are trying to write 500K rows to one sheet. Sent via BlackBerry -----Original Message----- From: suriz4u <[EMAIL PROTECTED]> Date: Thu, 10 Jul 2008 22:39:38 To: <[email protected]> Subject: Re: Its urgent===Please help 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]
