@Internal public abstract class BaseXSSFEvaluationWorkbook extends java.lang.Object implements FormulaRenderingWorkbook, EvaluationWorkbook, FormulaParsingWorkbook
EvaluationWorkbook.ExternalName, EvaluationWorkbook.ExternalSheet, EvaluationWorkbook.ExternalSheetRange
Modifier and Type | Field and Description |
---|---|
protected XSSFWorkbook |
_uBook |
Modifier | Constructor and Description |
---|---|
protected |
BaseXSSFEvaluationWorkbook(XSSFWorkbook book) |
Modifier and Type | Method and Description |
---|---|
void |
clearAllCachedResultValues()
Propagated from
WorkbookEvaluator.clearAllCachedResultValues() to clear locally cached data.
(从 WorkbookEvaluator.clearAllCachedResultValues() 传播以清除本地缓存的数据。)
|
int |
convertFromExternSheetIndex(int externSheetIndex)
XSSF doesn't use external sheet indexes, so when asked treat it just as a local index
(XSSF 不使用外部工作表索引,因此在询问时将其视为本地索引)
|
XSSFName |
createName()
Return the underlying workbook
(返回基础工作簿)
|
Ptg |
get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
Produce the appropriate Ptg for a 3d area reference
(为 3d 区域参考生成适当的 Ptg)
|
Ptg |
get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
Produce the appropriate Ptg for a 3d cell reference
(为 3d 单元格参考生成适当的 Ptg)
|
EvaluationWorkbook.ExternalName |
getExternalName(int externSheetIndex, int externNameIndex)
HSSF Only - fetch the external-style name details
(仅 HSSF - 获取外部样式名称详细信息)
|
EvaluationWorkbook.ExternalName |
getExternalName(java.lang.String nameName, java.lang.String sheetName, int externalWorkbookNumber)
XSSF Only - fetch the external-style name details
(仅限 XSSF - 获取外部样式名称详细信息)
|
EvaluationWorkbook.ExternalSheet |
getExternalSheet(int externSheetIndex)
HSSF Only - fetch the external-style sheet details
(仅 HSSF - 获取外部样式表详细信息)
|
EvaluationWorkbook.ExternalSheet |
getExternalSheet(java.lang.String firstSheetName, java.lang.String lastSheetName, int externalWorkbookNumber)
XSSF Only - fetch the external-style sheet details
(仅限 XSSF - 获取外部样式表详细信息)
|
int |
getExternalSheetIndex(java.lang.String sheetName)
gets the externSheet index for a sheet from this workbook
(从此工作簿中获取工作表的 externSheet 索引)
|
int |
getExternalSheetIndex(java.lang.String workbookName, java.lang.String sheetName)
gets the externSheet index for a sheet from an external workbook
(从外部工作簿获取工作表的 externSheet 索引)
|
EvaluationName |
getName(NamePtg namePtg) |
EvaluationName |
getName(java.lang.String name, int sheetIndex)
Return EvaluationName wrapper around the matching XSSFName (named range)
(在匹配的 XSSFName 周围返回 EvaluationName 包装器(命名范围))
|
java.lang.String |
getNameText(NamePtg namePtg) |
NameXPxg |
getNameXPtg(java.lang.String name, SheetIdentifier sheet)
Return an external name (named range, function, user-defined function) Pxg
(返回一个外部名称(命名范围、函数、用户定义函数) Pxg)
|
java.lang.String |
getSheetFirstNameByExternSheet(int externSheetIndex) |
int |
getSheetIndex(java.lang.String sheetName)
Finds a sheet index by case insensitive name.
(按不区分大小写的名称查找工作表索引。)
|
java.lang.String |
getSheetLastNameByExternSheet(int externSheetIndex) |
java.lang.String |
getSheetName(int sheetIndex) |
SpreadsheetVersion |
getSpreadsheetVersion()
Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)
(返回一个枚举,其中包含特定于 Excel 版本的 spreadhseet 属性(最大列数和行数、函数的最大参数等))
|
XSSFTable |
getTable(java.lang.String name)
Returns the data table with the given name (case insensitive).
(返回具有给定名称的数据表(不区分大小写)。)
|
UDFFinder |
getUDFFinder() |
java.lang.String |
resolveNameXText(NameXPtg n) |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getFormulaTokens, getSheet, getSheetIndex
protected final XSSFWorkbook _uBook
protected BaseXSSFEvaluationWorkbook(XSSFWorkbook book)
public void clearAllCachedResultValues()
EvaluationWorkbook
WorkbookEvaluator.clearAllCachedResultValues()
to clear locally cached data. Implementations must call the same method on all referenced
EvaluationSheet
instances, as well as clearing local caches.
(从 WorkbookEvaluator.clearAllCachedResultValues() 传播以清除本地缓存的数据。实现必须在所有引用的 EvaluationSheet 实例上调用相同的方法,并清除本地缓存。)
clearAllCachedResultValues
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 clearAllCachedResultValues)
WorkbookEvaluator.clearAllCachedResultValues()
public int convertFromExternSheetIndex(int externSheetIndex)
convertFromExternSheetIndex
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 convertFromExternSheetIndex)
public int getExternalSheetIndex(java.lang.String sheetName)
FormulaParsingWorkbook
getExternalSheetIndex
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getExternalSheetIndex)
public EvaluationName getName(java.lang.String name, int sheetIndex)
getName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getName)
getName
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getName)
name
- case-aware but case-insensitive named range in workbook
(name - 工作簿中区分大小写但不区分大小写的命名范围)
sheetIndex
- index of sheet if named range scope is limited to one sheet if named range scope is global to the workbook, sheetIndex is -1.
(sheetIndex - 如果命名范围范围限制为一张工作表,则工作表的索引如果命名范围范围对工作簿是全局的,则 sheetIndex 为 -1。)
public java.lang.String getSheetName(int sheetIndex)
getSheetName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheetName)
public EvaluationWorkbook.ExternalName getExternalName(int externSheetIndex, int externNameIndex)
EvaluationWorkbook
getExternalName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getExternalName)
public EvaluationWorkbook.ExternalName getExternalName(java.lang.String nameName, java.lang.String sheetName, int externalWorkbookNumber)
EvaluationWorkbook
getExternalName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getExternalName)
public NameXPxg getNameXPtg(java.lang.String name, SheetIdentifier sheet)
getNameXPtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getNameXPtg)
public Ptg get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
FormulaParsingWorkbook
get3DReferencePtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 get3DReferencePtg)
public Ptg get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
FormulaParsingWorkbook
get3DReferencePtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 get3DReferencePtg)
public java.lang.String resolveNameXText(NameXPtg n)
resolveNameXText
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 resolveNameXText)
resolveNameXText
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 resolveNameXText)
public EvaluationWorkbook.ExternalSheet getExternalSheet(int externSheetIndex)
EvaluationWorkbook
Return will have no workbook set if it's actually in our own workbook
(仅 HSSF - 获取外部样式表详细信息 Return 将没有工作簿集,如果它实际上在我们自己的工作簿中)getExternalSheet
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getExternalSheet)
getExternalSheet
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 getExternalSheet)
null
if externSheetIndex refers to a sheet inside the current workbook
(如果 externSheetIndex 引用当前工作簿中的工作表,则为 null)
public EvaluationWorkbook.ExternalSheet getExternalSheet(java.lang.String firstSheetName, java.lang.String lastSheetName, int externalWorkbookNumber)
EvaluationWorkbook
Return will have no workbook set if it's actually in our own workbook
(仅限 XSSF - 获取外部样式表详细信息 Return 将没有工作簿集,如果它实际上在我们自己的工作簿中)getExternalSheet
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getExternalSheet)
@NotImplemented public int getExternalSheetIndex(java.lang.String workbookName, java.lang.String sheetName)
FormulaParsingWorkbook
getExternalSheetIndex
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getExternalSheetIndex)
workbookName
- e.g. "Budget.xls"
(工作簿名称 - 例如“Budget.xls”)
sheetName
- a name of a sheet in that workbook
(sheetName - 该工作簿中工作表的名称)
public int getSheetIndex(java.lang.String sheetName)
EvaluationWorkbook
getSheetIndex
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheetIndex)
public java.lang.String getSheetFirstNameByExternSheet(int externSheetIndex)
getSheetFirstNameByExternSheet
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 getSheetFirstNameByExternSheet)
public java.lang.String getSheetLastNameByExternSheet(int externSheetIndex)
getSheetLastNameByExternSheet
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 getSheetLastNameByExternSheet)
public java.lang.String getNameText(NamePtg namePtg)
getNameText
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 getNameText)
public EvaluationName getName(NamePtg namePtg)
getName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getName)
public XSSFName createName()
FormulaParsingWorkbook
createName
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 createName)
public XSSFTable getTable(java.lang.String name)
getTable
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getTable)
name
- the data table name (case-insensitive)
(name - 数据表名称(不区分大小写))
public UDFFinder getUDFFinder()
getUDFFinder
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getUDFFinder)
public SpreadsheetVersion getSpreadsheetVersion()
FormulaParsingWorkbook
getSpreadsheetVersion
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSpreadsheetVersion)
getSpreadsheetVersion
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getSpreadsheetVersion)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.