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