Relative Content

Tag Archive for javaapache-poi

Apache POI: Unexpected eval class BlankEval

I’m trying to parse some excel files via Apache POI. For some files, I get error “Unexpected eval class (org.apache.poi.ss.formula.eval.BlankEval)” when trying to evaluate a cell’s formula. My code looks like this:

How to use XSSFFormulaEvaluator to evaluate formula?

I need to use POI to handle a Excel .xlsx file in Java.
There is SUM formula in my Excel template. (e.g. =SUM(C4:C7))
In the beginning, I use a existed method in our program, but it end in line 3 without exception throw and does not return outputStream.

Apache POI for Java

Depending on the value of the column cancelYn, if it is Y, a strikeout line is applied, and if it is N, it is not applied. Currently, strikethrough lines are appearing in all data.