Done.
Evaluating 10 big formula for 1000 times takes few seconds,
so must be some other step of the setCellFormula() method?
BTW, the example I linked is broken, since I do:
copyRow(workbook, sheet, 0, 1);
that is, I overwrite the same row multiple times.
If I change it to
copyRow(workbook, sheet, 0, i+1);
it's way faster.
Looking right now if I'm doing something stupid like that in the real code.
Thanks.
Raffaele
On 27/02/2012 14:37, Nick Burch wrote:
On Mon, 27 Feb 2012, Raffaele Castagno wrote:
You can estimate parsing time by calling the formula parser explicitly:
Ptg[] ptgs = HSSFFormulaParser.parse(formula, workbook);
Are you sure it is the bottleneck?
Tried some variations, been unable to test explicit formula parsing
You should try it, the code Yegor posted above is all you need. That will let
you be sure if it's the formula parsing or something else
Nick
---------------------------------------------------------------------
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]
