Im using poi-3.1-FINAL-20080629.jar version.I have a requirement of writing
5000+ records of data to a existing excel sheet which has many number of
formulas.The file size which im writing to is 15Mb,it has 10 sheets.
Im able to write the data successfully.But when i try to evaluate the cells
using the below code Im getting
Code:
HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(sheet, wb);
for(Iterator rit = sheet.rowIterator(); rit.hasNext();) {
HSSFRow r = (HSSFRow)rit.next();
evaluator.setCurrentRow(r);
for(Iterator cit = r.cellIterator(); cit.hasNext();) {
HSSFCell c = (HSSFCell)cit.next();
if(c.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
evaluator.evaluateFormulaCell(c);
}
}
}
Error:
java.lang.StackOverflowError
at java.lang.Character.codePointAt(Character.java:2335)
at java.util.regex.Pattern$BitClass.match(Pattern.java:2873)
at java.util.regex.Pattern$Sub.match(Pattern.java:5252)
I have tested the same peice of code with poi-3.5-beta3-20080926.jar the
code works fine
I cant move poi beta version to be moved to production environment.
Pls help me out
Cheers,
Sc
--
View this message in context:
http://www.nabble.com/HSSFFormulaEvaluator---evaluateFormulaCell-StackOverFlow-error-tp19980950p19980950.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]
