public final class SXSSFFormulaEvaluator extends BaseXSSFFormulaEvaluator
Modifier and Type | Class and Description |
---|---|
static class |
SXSSFFormulaEvaluator.RowFlushedException |
static class |
SXSSFFormulaEvaluator.SheetsFlushedException |
Constructor and Description |
---|
SXSSFFormulaEvaluator(SXSSFWorkbook workbook) |
Modifier and Type | Method and Description |
---|---|
static SXSSFFormulaEvaluator |
create(SXSSFWorkbook workbook,
IStabilityClassifier stabilityClassifier,
UDFFinder udfFinder) |
void |
evaluateAll()
Loops over rows and cells, evaluating formula cells there.
|
static void |
evaluateAllFormulaCells(SXSSFWorkbook wb,
boolean skipOutOfWindow)
For active worksheets only, will loop over rows and
cells, evaluating formula cells there.
|
SXSSFCell |
evaluateInCell(Cell cell)
If cell contains formula, it evaluates the formula, and
puts the formula result back into the cell, in place
of the old formula.
|
protected EvaluationCell |
toEvaluationCell(Cell cell)
Turns a SXSSFCell into a SXSSFEvaluationCell
|
_getWorkbookEvaluator, clearAllCachedResultValues, doEvaluateInCell, evaluate, evaluateFormulaCell, notifyDeleteCell, notifySetFormula, notifyUpdateCell, setDebugEvaluationOutputForNextEval, setIgnoreMissingWorkbooks, setupReferencedWorkbooks
public SXSSFFormulaEvaluator(SXSSFWorkbook workbook)
public static SXSSFFormulaEvaluator create(SXSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder)
stabilityClassifier
- used to optimise caching performance. Pass null
for the (conservative) assumption that any cell may have its definition changed after
evaluation begins.udfFinder
- pass null
for default (AnalysisToolPak only)protected EvaluationCell toEvaluationCell(Cell cell)
toEvaluationCell
in class BaseXSSFFormulaEvaluator
public SXSSFCell evaluateInCell(Cell cell)
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
BaseXSSFFormulaEvaluator.evaluateFormulaCell(org.apache.poi.ss.usermodel.Cell)
}public static void evaluateAllFormulaCells(SXSSFWorkbook wb, boolean skipOutOfWindow)
public void evaluateAll()
Copyright 2017 The Apache Software Foundation or its licensors, as applicable.