HSSFEvaluationWorkbook
, XSSFEvaluationWorkbook
public interface FormulaParsingWorkbook
Modifier and Type | Method | Description |
---|---|---|
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
|
NameXPtg |
getNameXPtg(java.lang.String name) |
|
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)
NameXPtg getNameXPtg(java.lang.String name)
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.