You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by suriz4u <su...@gmail.com> on 2008/07/10 14:13:13 UTC
Its urgent===Please help
Hi
First of all thanks for sparing time and looking over my post..
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.Or if iam using two
sessions which generates two lakh rows each(2*2=4lakhs),then also iam
getting out of memory error.Iam I kept debug statement before
workBook.write(out);
Application works up to that point and after some time it gives Out of
Memory error.So can any one help me out please.
Thanks
Suresh G
--
View this message in context: http://www.nabble.com/Its-urgent%3D%3D%3DPlease--help-tp18381577p18381577.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by suriz4u <su...@gmail.com>.
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.
>
> Increase your JVM heap size. The default is much too small anyway, and
> especially when dealing with excel, which isn't a file format that's well
> designed for being operated on in a memory efficient manner :(
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Its-urgent%3D%3D%3DPlease--help-tp18381577p18382934.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by Nick Burch <ni...@torchbox.com>.
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.
Increase your JVM heap size. The default is much too small anyway, and
especially when dealing with excel, which isn't a file format that's well
designed for being operated on in a memory efficient manner :(
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by David Fisher <df...@jmlafferty.com>.
Hi Suresh,
Since you split the data into multiple worksheets, then why not split
it into multiple workbooks?
The trouble you encounter is that due to the Excel file format being a
random access file with pointers all over to various objects the POI
implementation requires the whole workbook reside in memory before it
can be written.
The size of each object is small and that adds more memory overhead.
So, now you have received all the conventional advice we have for you.
BTW - there is a reason that there is Access and databases - handling
lahks of data :-)
Good luck,
Dave
On Jul 11, 2008, at 5:38 AM, suriz4u wrote:
>
>
> 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 <mg...@gmail.com> wrote:
>> From: Mahesh Ganapathy <mg...@gmail.com>
>> Subject: Re: Its urgent===Please help
>> To: "POI Users List" <us...@poi.apache.org>
>> 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 <su...@gmail.com>
>>
>> Date: Thu, 10 Jul 2008 22:39:38
>> To: <us...@poi.apache.org>
>> 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 <Ke...@ccbai.com>
>>>>> Sent: Thursday, July 10, 2008 10:20 AM
>>>>> To: POI Users List <us...@poi.apache.org>
>>>>> 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:suriz4u@gmail.com]
>>>>> Sent: Thursday, July 10, 2008 9:33 AM
>>>>> To: user@poi.apache.org
>>>>> 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: user-unsubscribe@poi.apache.org
>>>>> For additional commands, e-mail: user-help@poi.apache.org
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>> 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: user-unsubscribe@poi.apache.org
>>>> For additional commands, e-mail: user-help@poi.apache.org
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>>
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by suriz4u <su...@gmail.com>.
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 <mg...@gmail.com> wrote:
> From: Mahesh Ganapathy <mg...@gmail.com>
> Subject: Re: Its urgent===Please help
> To: "POI Users List" <us...@poi.apache.org>
> 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 <su...@gmail.com>
>
> Date: Thu, 10 Jul 2008 22:39:38
> To: <us...@poi.apache.org>
> 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 <Ke...@ccbai.com>
>>>> Sent: Thursday, July 10, 2008 10:20 AM
>>>> To: POI Users List <us...@poi.apache.org>
>>>> 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:suriz4u@gmail.com]
>>>> Sent: Thursday, July 10, 2008 9:33 AM
>>>> To: user@poi.apache.org
>>>> 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: user-unsubscribe@poi.apache.org
>>>> For additional commands, e-mail: user-help@poi.apache.org
>>>>
>>>>
>>>>
>>>
>>> --
>>> 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: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by Daniel Noll <da...@nuix.com>.
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.
That being said, the limit for HSSF (with -Xmx1g) is around 6,000,000
empty cells, which can be reached without exceeding the maximum row or
column count.
Daniel
--
Daniel Noll
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by Anthony Andrews <py...@yahoo.com>.
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 <mg...@gmail.com> wrote:
From: Mahesh Ganapathy <mg...@gmail.com>
Subject: Re: Its urgent===Please help
To: "POI Users List" <us...@poi.apache.org>
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 <su...@gmail.com>
Date: Thu, 10 Jul 2008 22:39:38
To: <us...@poi.apache.org>
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 <Ke...@ccbai.com>
>>> Sent: Thursday, July 10, 2008 10:20 AM
>>> To: POI Users List <us...@poi.apache.org>
>>> 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:suriz4u@gmail.com]
>>> Sent: Thursday, July 10, 2008 9:33 AM
>>> To: user@poi.apache.org
>>> 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: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by Mahesh Ganapathy <mg...@gmail.com>.
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 <su...@gmail.com>
Date: Thu, 10 Jul 2008 22:39:38
To: <us...@poi.apache.org>
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 <Ke...@ccbai.com>
>>> Sent: Thursday, July 10, 2008 10:20 AM
>>> To: POI Users List <us...@poi.apache.org>
>>> 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:suriz4u@gmail.com]
>>> Sent: Thursday, July 10, 2008 9:33 AM
>>> To: user@poi.apache.org
>>> 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: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by suriz4u <su...@gmail.com>.
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 <Ke...@ccbai.com>
>>> Sent: Thursday, July 10, 2008 10:20 AM
>>> To: POI Users List <us...@poi.apache.org>
>>> 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:suriz4u@gmail.com]
>>> Sent: Thursday, July 10, 2008 9:33 AM
>>> To: user@poi.apache.org
>>> 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: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>
>>
>> --
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Its urgent===Please help
Posted by David Fisher <df...@jmlafferty.com>.
Did you try 1500M? If you did 1500 then that is thousands and equal
to1.5 lakh. Not enough is it?
What is your java command line exactly?
Also, is your xls formatted or plain?
How many columns on each row?
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 <Ke...@ccbai.com>
>> Sent: Thursday, July 10, 2008 10:20 AM
>> To: POI Users List <us...@poi.apache.org>
>> 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:suriz4u@gmail.com]
>> Sent: Thursday, July 10, 2008 9:33 AM
>> To: user@poi.apache.org
>> 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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>
> --
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Its urgent===Please help
Posted by "Kumar, Ravendra" <ra...@logica.com>.
Just use csv format to write 500000 rows
-Ravendra
-----Original Message-----
From: suriz4u [mailto:suriz4u@gmail.com]
Sent: Friday, July 11, 2008 10:47 AM
To: user@poi.apache.org
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 <Ke...@ccbai.com>
> Sent: Thursday, July 10, 2008 10:20 AM
> To: POI Users List <us...@poi.apache.org>
> 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:suriz4u@gmail.com]
> Sent: Thursday, July 10, 2008 9:33 AM
> To: user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Its urgent===Please help
Posted by suriz4u <su...@gmail.com>.
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 <Ke...@ccbai.com>
> Sent: Thursday, July 10, 2008 10:20 AM
> To: POI Users List <us...@poi.apache.org>
> 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:suriz4u@gmail.com]
> Sent: Thursday, July 10, 2008 9:33 AM
> To: user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org