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, setupReferencedWorkbookspublic 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 BaseXSSFFormulaEvaluatorpublic 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.