public final class OperationEvaluationContext
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
UDF |
Constructor and Description |
---|
OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.apache.poi.ss.formula.EvaluationTracker tracker) |
OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.apache.poi.ss.formula.EvaluationTracker tracker, boolean isSingleValue) |
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
findUserDefinedFunction(java.lang.String functionName) |
ValueEval |
getArea3DEval(Area3DPtg aptg) |
ValueEval |
getArea3DEval(Area3DPxg aptg) |
ValueEval |
getAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex) |
ValueEval |
getAreaValueEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, java.lang.Object[][] tokens) |
int |
getColumnIndex() |
ValueEval |
getDynamicReference(java.lang.String workbookName, java.lang.String sheetName, java.lang.String refStrPart1, java.lang.String refStrPart2, boolean isA1Style)
Resolves a cell or area reference dynamically.
(动态解析单元格或区域引用。)
|
ValueEval |
getNameXEval(NameXPtg nameXPtg) |
ValueEval |
getNameXEval(NameXPxg nameXPxg) |
ValueEval |
getRef3DEval(Ref3DPtg rptg) |
ValueEval |
getRef3DEval(Ref3DPxg rptg) |
ValueEval |
getRefEval(int rowIndex, int columnIndex) |
org.apache.poi.ss.formula.SheetRangeEvaluator |
getRefEvaluatorForCurrentSheet() |
int |
getRowIndex() |
int |
getSheetIndex() |
EvaluationWorkbook |
getWorkbook() |
boolean |
isArraymode() |
boolean |
isSingleValue()
default true
(默认为真)
|
void |
setArrayMode(boolean value) |
public static final FreeRefFunction UDF
public OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.apache.poi.ss.formula.EvaluationTracker tracker)
public OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.apache.poi.ss.formula.EvaluationTracker tracker, boolean isSingleValue)
public boolean isArraymode()
public void setArrayMode(boolean value)
public EvaluationWorkbook getWorkbook()
public int getRowIndex()
public int getColumnIndex()
public org.apache.poi.ss.formula.SheetRangeEvaluator getRefEvaluatorForCurrentSheet()
public ValueEval getDynamicReference(java.lang.String workbookName, java.lang.String sheetName, java.lang.String refStrPart1, java.lang.String refStrPart2, boolean isA1Style)
workbookName
- the name of the workbook containing the reference. If
null
the current workbook is assumed. Note - to evaluate formulas which use multiple workbooks, a
CollaboratingWorkbooksEnvironment
must be set up.
(workbookName - 包含引用的工作簿的名称。如果为 null,则假定为当前工作簿。注意 - 要评估使用多个工作簿的公式,必须设置 CollaboratingWorkbooksEnvironment。)
sheetName
- the name of the sheet containing the reference. May be
null
(when
workbookName is also null) in which case the current workbook and sheet is assumed.
(sheetName - 包含引用的工作表的名称。可能为 null(当 workbookName 也为 null 时),在这种情况下假定当前工作簿和工作表。)
refStrPart1
- the single cell reference or first part of the area reference. Must not be
null
.
(refStrPart1 - 单个单元格引用或区域引用的第一部分。不得为空。)
refStrPart2
- the second part of the area reference. For single cell references this parameter must be
null
(refStrPart2 - 区域参考的第二部分。对于单个单元格引用,此参数必须为 null)
isA1Style
- specifies the format for
refStrPart1 and
refStrPart2. Pass
true
for 'A1' style and
false
for 'R1C1' style. TODO - currently POI only supports 'A1' reference style
(isA1Style - 指定 refStrPart1 和 refStrPart2 的格式。为“A1”样式传递 true,为“R1C1”样式传递 false。 TODO - 目前 POI 仅支持 'A1' 参考样式)
RefEval
or
AreaEval
(RefEval 或 AreaEval)
public FreeRefFunction findUserDefinedFunction(java.lang.String functionName)
public ValueEval getRefEval(int rowIndex, int columnIndex)
public ValueEval getAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex)
public ValueEval getAreaValueEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, java.lang.Object[][] tokens)
public int getSheetIndex()
public boolean isSingleValue()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.