Hi All,
Can anyone please help me out..
Cheers,
Sc
Sharath2k wrote:
>
>
>
> 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-tp19980950p19992845.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]
