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 <[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]

Reply via email to