HSSFEvaluationWorkbook
, XSSFEvaluationWorkbook
public interface FormulaParsingWorkbook
Modifier and Type | Method | Description |
---|---|---|
Ptg |
get3DReferencePtg(AreaReference area,
SheetIdentifier sheet) |
Produce the appropriate Ptg for a 3d area reference
|
Ptg |
get3DReferencePtg(CellReference cell,
SheetIdentifier sheet) |
Produce the appropriate Ptg for a 3d cell reference
|
int |
getExternalSheetIndex(java.lang.String sheetName) |
gets the externSheet index for a sheet from this workbook
|
int |
getExternalSheetIndex(java.lang.String workbookName,
java.lang.String sheetName) |
gets the externSheet index for a sheet from an external workbook
|
EvaluationName |
getName(java.lang.String name,
int sheetIndex) |
named range name matching is case insensitive
|
Ptg |
getNameXPtg(java.lang.String name,
SheetIdentifier sheet) |
|
SpreadsheetVersion |
getSpreadsheetVersion() |
Returns an enum holding spreadhseet properties specific to an Excel version (
max column and row numbers, max arguments to a function, etc.)
|
EvaluationName getName(java.lang.String name, int sheetIndex)
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"sheetName
- a name of a sheet in that workbookSpreadsheetVersion getSpreadsheetVersion()
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.