getEvaluationWorkbook

clearAllCachedResultValues

public void clearAllCachedResultValues()

Should be called whenever there are major changes (e.g. moving sheets) to input cells
in the evaluated workbook. If performance is not critical, a single call to this method
may be used instead of many specific calls to the notify~ methods.
Failure to call this method after changing cell values will cause incorrect behaviour
of the evaluate~ methods of this class

evaluate

If cell contains a formula, the formula is evaluated and returned,
else the CellValue simply copies the appropriate cell value from
the cell and also its cell type. This method should be preferred over
evaluateInCell() when the call should not modify the contents of the
original cell.

evaluateInCell

If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
Else if cell does not contain formula, this method leaves
the cell unchanged.
Note that the same instance of Cell is returned to
allow chained calls like:

int evaluatedCellType = evaluator.evaluateInCell(cell).getCellType();

Be aware that your cell value will be changed to hold the
result of the formula. If you simply want the formula
value computed for you, use evaluateFormulaCell(Cell)}

evaluateFormulaCellValue

evaluateFormulaCell

If cell contains formula, it evaluates the formula,
and saves the result of the formula. The cell
remains as a formula cell.
Else if cell does not contain formula, this method leaves
the cell unchanged.
Note that the type of the formula result is returned,
so you know what kind of value is also stored with
the formula.

evaluateFormulaCellEnum

If cell contains formula, it evaluates the formula,
and saves the result of the formula. The cell
remains as a formula cell.
Else if cell does not contain formula, this method leaves
the cell unchanged.
Note that the type of the formula result is returned,
so you know what kind of value is also stored with
the formula.

setCellValue

evaluateAllFormulaCells

Loops over all cells in all sheets of the supplied
workbook.
For cells that contain formulas, their formulas are
evaluated, and the results are saved. These cells
remain as formula cells.
For cells that do not contain formulas, no changes
are made.
This is a helpful wrapper around looping over all
cells, and calling evaluateFormulaCell on each one.

setDebugEvaluationOutputForNextEval

public void setDebugEvaluationOutputForNextEval(boolean value)

Perform detailed output of formula evaluation for next evaluation only?
Is for developer use only (also developers using POI for their XLS files).
Log-Level WARN is for basic info, INFO for detailed information. These quite
high levels are used because you have to explicitly enable this specific logging.