|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.ss.usermodel.FormulaEvaluator
public class FormulaEvaluator
Nested Class Summary | |
---|---|
static class |
FormulaEvaluator.CellValue
Mimics the 'data view' of a cell. |
Field Summary | |
---|---|
protected org.apache.poi.ss.usermodel.Row |
row
|
protected org.apache.poi.ss.usermodel.Sheet |
sheet
|
protected org.apache.poi.ss.usermodel.Workbook |
workbook
|
Constructor Summary | |
---|---|
FormulaEvaluator(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook workbook)
|
Method Summary | |
---|---|
FormulaEvaluator.CellValue |
evaluate(org.apache.poi.ss.usermodel.Cell cell)
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. |
static void |
evaluateAllFormulaCells(org.apache.poi.ss.usermodel.Workbook wb)
Loops over all cells in all sheets of the supplied workbook. |
static AreaEval |
evaluateArea3dPtg(org.apache.poi.ss.usermodel.Workbook workbook,
Area3DPtg a3dp)
|
static AreaEval |
evaluateAreaPtg(org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook workbook,
AreaPtg ap)
|
int |
evaluateFormulaCell(org.apache.poi.ss.usermodel.Cell cell)
If cell contains formula, it evaluates the formula, and saves the result of the formula. |
org.apache.poi.ss.usermodel.Cell |
evaluateInCell(org.apache.poi.ss.usermodel.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 static FormulaEvaluator.CellValue |
getCellValueForEval(ValueEval eval,
org.apache.poi.ss.usermodel.CreationHelper cHelper)
Returns a CellValue wrapper around the supplied ValueEval instance. |
protected static ValueEval |
getEvalForCell(org.apache.poi.ss.usermodel.Cell cell,
org.apache.poi.ss.usermodel.Row row,
org.apache.poi.ss.usermodel.Sheet sheet,
org.apache.poi.ss.usermodel.Workbook workbook)
Given a cell, find its type and from that create an appropriate ValueEval impl instance and return that. |
protected static Eval |
getEvalForPtg(Ptg ptg)
returns an appropriate Eval impl instance for the Ptg. |
void |
setCurrentRow(org.apache.poi.ss.usermodel.Row row)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
protected org.apache.poi.ss.usermodel.Row row
protected org.apache.poi.ss.usermodel.Sheet sheet
protected org.apache.poi.ss.usermodel.Workbook workbook
Constructor Detail |
---|
public FormulaEvaluator(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook)
Method Detail |
---|
public void setCurrentRow(org.apache.poi.ss.usermodel.Row row)
public FormulaEvaluator.CellValue evaluate(org.apache.poi.ss.usermodel.Cell cell)
cell
- public int evaluateFormulaCell(org.apache.poi.ss.usermodel.Cell cell)
int evaluatedCellType = evaluator.evaluateFormulaCell(cell);Be aware that your cell will hold both the formula, and the result. If you want the cell replaced with the result of the formula, use
#evaluateInCell(HSSFCell)
cell
- The cell to evaluate
public org.apache.poi.ss.usermodel.Cell evaluateInCell(org.apache.poi.ss.usermodel.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
#evaluateFormulaCell(HSSFCell)
cell
- public static void evaluateAllFormulaCells(org.apache.poi.ss.usermodel.Workbook wb)
protected static FormulaEvaluator.CellValue getCellValueForEval(ValueEval eval, org.apache.poi.ss.usermodel.CreationHelper cHelper)
eval
- public static AreaEval evaluateAreaPtg(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook, AreaPtg ap)
public static AreaEval evaluateArea3dPtg(org.apache.poi.ss.usermodel.Workbook workbook, Area3DPtg a3dp)
protected static Eval getEvalForPtg(Ptg ptg)
ptg
- protected static ValueEval getEvalForCell(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.Row row, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Workbook workbook)
cell
- sheet
- workbook
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |