Hey,that made sense...Thanks a lot..but how do you explicitly deallocate
memeory.I make the the instance of workbook nullafter every
creation..Any other way? And how to make gc a high priority process.
Warm Regards,
Mili Aggarwal
HCL TECHNOLOGIES LTD.
Noida, India.
Tel: +91 (0120)
Hi Mili,
Calling Runtime.gc() as you are doing signals the Garbage Collector to
collect garbage as soon as possible. Afaik that's all you can do. However,
as soon as possible gives absolutely no guarantees, so you can't rely on
it doing it on time.
You can try calling Thread.yield() after calling
Hi!
To my knowledge there isnt a way to copy cellmerging from sheet a to sheet b? Im
having problems to copy rows from an other xls file in to my new one. I thought
this code should copy value and cellstyle. Im getting the value but it inserts
at the wrong cell in the new sheet. And the style i
Here is the exception info that was left out of yesterday's post.
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
at java.lang.String.charAt(String.java:1037)
at
org.apache.poi.hssf.util.CellReference.init(CellReference.java:49)
at
If you are using a template, and all you want to do is enforce
recalculation, use a startup macro to force recalc at opening.
On Wed, 2005-04-06 at 09:54 -0400, Randy Tate wrote:
Here is the exception info that was left out of yesterday's post.
java.lang.StringIndexOutOfBoundsException:
Well it looks like the formula ends abruptly (maybe something like a missing
closing paren?), causing the StringOutOfBoundsException. Maybe you can show
the piece of code that's causing the exception (get the line number from the
stack trace), including the formula you're writing to the cell.
I can call the method below and all is fine up to a certain point(number
of cells with formulae). Once I add more cells beyond that point, the
error is thrown and cells previously working will be the point of error.
The formula being returned and displayed will be correct until the
number is
can you run a biffview on this to ensure you dont have a shared formula
in there?
if possible attach the offending template and the code to reproduce the
problem to bugzilla.
thanks.
Randy Tate wrote:
I can call the method below and all is fine up to a certain point(number
of cells with
He guys I have be unable to resolve out of memory error when I am creating
300 odd workbooks.
The structure of my app is:
Reportgenerater is the class that calls 2 classes((Sheet1 and Sheet2)) by
passing them workbook object to Create sheets. The 2 classes create one
sheet each. There is a common