public interface FormulaParsingWorkbook
Modifier and Type | Method and Description |
---|---|
Name |
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)
|
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(java.lang.String name, int sheetIndex)
named range name matching is case insensitive
(命名范围名称匹配不区分大小写)
|
Ptg |
getNameXPtg(java.lang.String name, SheetIdentifier sheet)
Return an external name (named range, function, user-defined function) Ptg
(返回一个外部名称(命名范围、函数、用户定义函数)Ptg)
|
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 - 获取工作表中存在的表)
|
EvaluationName getName(java.lang.String name, int sheetIndex)
Name createName()
Table getTable(java.lang.String name)
Ptg getNameXPtg(java.lang.String name, SheetIdentifier sheet)
Ptg get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
Ptg get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
int getExternalSheetIndex(java.lang.String sheetName)
int getExternalSheetIndex(java.lang.String workbookName, java.lang.String sheetName)
workbookName
- e.g. "Budget.xls"
(工作簿名称 - 例如“Budget.xls”)
sheetName
- a name of a sheet in that workbook
(sheetName - 该工作簿中工作表的名称)
SpreadsheetVersion getSpreadsheetVersion()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.