public final class HSSFEvaluationWorkbook extends java.lang.Object implements FormulaRenderingWorkbook, EvaluationWorkbook, FormulaParsingWorkbook
EvaluationWorkbook.ExternalName, EvaluationWorkbook.ExternalSheet| Modifier and Type | Method and Description |
|---|---|
int |
convertFromExternSheetIndex(int externSheetIndex) |
static HSSFEvaluationWorkbook |
create(HSSFWorkbook book) |
EvaluationWorkbook.ExternalName |
getExternalName(int externSheetIndex,
int externNameIndex) |
EvaluationWorkbook.ExternalSheet |
getExternalSheet(int externSheetIndex) |
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
|
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) |
EvaluationSheet |
getSheet(int sheetIndex) |
int |
getSheetIndex(EvaluationSheet evalSheet) |
int |
getSheetIndex(java.lang.String sheetName)
Finds a sheet index by case insensitive name.
|
java.lang.String |
getSheetName(int sheetIndex) |
java.lang.String |
getSheetNameByExternSheet(int externSheetIndex) |
SpreadsheetVersion |
getSpreadsheetVersion()
Returns an enum holding spreadhseet properties specific to an Excel version (
max column and row numbers, max arguments to a function, etc.)
|
UDFFinder |
getUDFFinder() |
java.lang.String |
resolveNameXText(NameXPtg n) |
public static HSSFEvaluationWorkbook create(HSSFWorkbook book)
public int getExternalSheetIndex(java.lang.String sheetName)
FormulaParsingWorkbookgetExternalSheetIndex in interface FormulaParsingWorkbookpublic int getExternalSheetIndex(java.lang.String workbookName,
java.lang.String sheetName)
FormulaParsingWorkbookgetExternalSheetIndex in interface FormulaParsingWorkbookworkbookName - e.g. "Budget.xls"sheetName - a name of a sheet in that workbookpublic NameXPtg getNameXPtg(java.lang.String name)
getNameXPtg in interface FormulaParsingWorkbookpublic EvaluationName getName(java.lang.String name, int sheetIndex)
getName in interface EvaluationWorkbookgetName in interface FormulaParsingWorkbookname - the name to searchsheetIndex - 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 namespublic int getSheetIndex(EvaluationSheet evalSheet)
getSheetIndex in interface EvaluationWorkbookpublic int getSheetIndex(java.lang.String sheetName)
EvaluationWorkbookgetSheetIndex in interface EvaluationWorkbookpublic java.lang.String getSheetName(int sheetIndex)
getSheetName in interface EvaluationWorkbookpublic EvaluationSheet getSheet(int sheetIndex)
getSheet in interface EvaluationWorkbookpublic int convertFromExternSheetIndex(int externSheetIndex)
convertFromExternSheetIndex in interface EvaluationWorkbookpublic EvaluationWorkbook.ExternalSheet getExternalSheet(int externSheetIndex)
getExternalSheet in interface EvaluationWorkbookgetExternalSheet in interface FormulaRenderingWorkbooknull if externSheetIndex refers to a sheet inside the current workbookpublic EvaluationWorkbook.ExternalName getExternalName(int externSheetIndex, int externNameIndex)
getExternalName in interface EvaluationWorkbookpublic java.lang.String resolveNameXText(NameXPtg n)
resolveNameXText in interface EvaluationWorkbookresolveNameXText in interface FormulaRenderingWorkbookpublic java.lang.String getSheetNameByExternSheet(int externSheetIndex)
getSheetNameByExternSheet in interface FormulaRenderingWorkbookpublic java.lang.String getNameText(NamePtg namePtg)
getNameText in interface FormulaRenderingWorkbookpublic EvaluationName getName(NamePtg namePtg)
getName in interface EvaluationWorkbookpublic Ptg[] getFormulaTokens(EvaluationCell evalCell)
getFormulaTokens in interface EvaluationWorkbookpublic UDFFinder getUDFFinder()
getUDFFinder in interface EvaluationWorkbookpublic SpreadsheetVersion getSpreadsheetVersion()
FormulaParsingWorkbookgetSpreadsheetVersion in interface FormulaParsingWorkbookCopyright 2014 The Apache Software Foundation or its licensors, as applicable.