@Internal public final class HSSFEvaluationWorkbook extends java.lang.Object implements FormulaRenderingWorkbook, EvaluationWorkbook, FormulaParsingWorkbook
EvaluationWorkbook.ExternalName, EvaluationWorkbook.ExternalSheet, EvaluationWorkbook.ExternalSheetRange
Modifier and Type | Method and Description |
---|---|
void |
clearAllCachedResultValues()
Propagated from
WorkbookEvaluator.clearAllCachedResultValues() to clear locally cached data.
(从 WorkbookEvaluator.clearAllCachedResultValues() 传播以清除本地缓存的数据。)
|
int |
convertFromExternSheetIndex(int externSheetIndex)
HSSF Only - convert an external sheet index to an internal sheet index, for an external-style reference to one of this workbook's own sheets
(仅 HSSF - 将外部工作表索引转换为内部工作表索引,以获取对此工作簿自己工作表之一的外部样式引用)
|
static HSSFEvaluationWorkbook |
create(HSSFWorkbook book) |
HSSFName |
createName()
Return the underlying workbook
(返回基础工作簿)
|
Ptg |
get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)
Produce the appropriate Ptg for a 3d area reference
(为 3d 区域参考生成适当的 Ptg)
|
Ptg |
get3DReferencePtg(CellReference cr, 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 索引)
|
Ptg[] |
getFormulaTokens(EvaluationCell evalCell) |
EvaluationName |
getName(NamePtg namePtg) |
EvaluationName |
getName(java.lang.String name, int sheetIndex)
Lookup a named range by its name.
(按名称查找命名范围。)
|
java.lang.String |
getNameText(NamePtg namePtg) |
NameXPtg |
getNameXPtg(java.lang.String name, SheetIdentifier sheet)
Return an external name (named range, function, user-defined function) Ptg
(返回一个外部名称(命名范围、函数、用户定义函数)Ptg)
|
EvaluationSheet |
getSheet(int sheetIndex) |
java.lang.String |
getSheetFirstNameByExternSheet(int externSheetIndex) |
int |
getSheetIndex(EvaluationSheet evalSheet) |
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 属性(最大列数和行数、函数的最大参数等))
|
Table |
getTable(java.lang.String name)
XSSF Only - gets a table that exists in the worksheet
(仅限 XSSF - 获取工作表中存在的表)
|
UDFFinder |
getUDFFinder() |
java.lang.String |
resolveNameXText(NameXPtg n) |
public static HSSFEvaluationWorkbook create(HSSFWorkbook 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 HSSFName createName()
FormulaParsingWorkbook
createName
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 createName)
public int getExternalSheetIndex(java.lang.String sheetName)
FormulaParsingWorkbook
getExternalSheetIndex
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getExternalSheetIndex)
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 Ptg get3DReferencePtg(CellReference cr, SheetIdentifier sheet)
FormulaParsingWorkbook
get3DReferencePtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 get3DReferencePtg)
public Ptg get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)
FormulaParsingWorkbook
get3DReferencePtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 get3DReferencePtg)
public NameXPtg getNameXPtg(java.lang.String name, SheetIdentifier sheet)
getNameXPtg
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getNameXPtg)
public EvaluationName getName(java.lang.String name, int sheetIndex)
getName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getName)
getName
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getName)
name
- the name to search
(name - 要搜索的名称)
sheetIndex
- the 0-based index of the sheet this formula belongs to. The sheet index is required to resolve sheet-level names.
-1
means workbook-global names
(sheetIndex - 此公式所属工作表的从 0 开始的索引。需要工作表索引来解析工作表级名称。 -1 表示工作簿全局名称)
public int getSheetIndex(EvaluationSheet evalSheet)
getSheetIndex
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheetIndex)
public int getSheetIndex(java.lang.String sheetName)
EvaluationWorkbook
getSheetIndex
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheetIndex)
public java.lang.String getSheetName(int sheetIndex)
getSheetName
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheetName)
public EvaluationSheet getSheet(int sheetIndex)
getSheet
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getSheet)
public int convertFromExternSheetIndex(int externSheetIndex)
EvaluationWorkbook
convertFromExternSheetIndex
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 convertFromExternSheetIndex)
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)
IllegalStateException:
- XSSF-style external references are not supported for HSSF
(IllegalStateException: - HSSF 不支持 XSSF 样式的外部引用)
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)
IllegalStateException:
- XSSF-style external names are not supported for HSSF
(IllegalStateException: - HSSF 不支持 XSSF 样式的外部名称)
public java.lang.String resolveNameXText(NameXPtg n)
resolveNameXText
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 resolveNameXText)
resolveNameXText
in interface
FormulaRenderingWorkbook
(接口 FormulaRenderingWorkbook 中的 resolveNameXText)
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 Ptg[] getFormulaTokens(EvaluationCell evalCell)
getFormulaTokens
in interface
EvaluationWorkbook
(接口 EvaluationWorkbook 中的 getFormulaTokens)
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)
public Table getTable(java.lang.String name)
FormulaParsingWorkbook
getTable
in interface
FormulaParsingWorkbook
(接口 FormulaParsingWorkbook 中的 getTable)
IllegalStateException:
- data tables are not supported in Excel 97-2003 format
(IllegalStateException: - Excel 97-2003 格式不支持数据表)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.