|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator
org.apache.poi.xssf.streaming.SXSSFFormulaEvaluator
public final class SXSSFFormulaEvaluator
Streaming-specific Formula Evaluator, which is able to lookup cells within the current Window.
Nested Class Summary | |
---|---|
static class |
SXSSFFormulaEvaluator.RowFlushedException
|
static class |
SXSSFFormulaEvaluator.SheetsFlushedException
|
Constructor Summary | |
---|---|
SXSSFFormulaEvaluator(SXSSFWorkbook workbook)
|
Method Summary | |
---|---|
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 |
Methods inherited from class org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator |
---|
_getWorkbookEvaluator, clearAllCachedResultValues, doEvaluateInCell, evaluate, evaluateFormulaCell, notifyDeleteCell, notifySetFormula, notifyUpdateCell, setDebugEvaluationOutputForNextEval, setIgnoreMissingWorkbooks, setupReferencedWorkbooks |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SXSSFFormulaEvaluator(SXSSFWorkbook workbook)
Method Detail |
---|
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()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |