poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From suriz4u <suri...@gmail.com>
Subject Re: Its urgent===Please help
Date Fri, 11 Jul 2008 05:39:38 GMT

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 <Kendall.Coolidge@ccbai.com>
>>> Sent: Thursday, July 10, 2008 10:20 AM
>>> To: POI Users List <user@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


Mime
View raw message