I mean iam writing data into multiple sheets and if total no of rows is >=5lakh iam getting out of memory error.So can u please tell me how to avoid this error while using POI
Thanks Suresh G Anthony Andrews wrote: > > 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] > > > > -- View this message in context: http://www.nabble.com/Its-urgent%3D%3D%3DPlease--help-tp18381577p18401006.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]
