Package org.apache.poi.ss.formula
Interface FormulaParsingWorkbook
- All Known Implementing Classes:
BaseXSSFEvaluationWorkbook
,HSSFEvaluationWorkbook
,SXSSFEvaluationWorkbook
,XSSFEvaluationWorkbook
public interface FormulaParsingWorkbook
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only
For POI internal use only
- Author:
- Josh Micich
-
Method Summary
Modifier and TypeMethodDescriptionReturn the underlying workbookget3DReferencePtg
(AreaReference area, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d area referenceget3DReferencePtg
(CellReference cell, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d cell referenceint
getExternalSheetIndex
(String sheetName) gets the externSheet index for a sheet from this workbookint
getExternalSheetIndex
(String workbookName, String sheetName) gets the externSheet index for a sheet from an external workbooknamed range name matching is case insensitivegetNameXPtg
(String name, SheetIdentifier sheet) Return an external name (named range, function, user-defined function) PtgReturns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)XSSF Only - gets a table that exists in the worksheet
-
Method Details
-
getName
named range name matching is case insensitive -
createName
Name createName()Return the underlying workbook -
getTable
XSSF Only - gets a table that exists in the worksheet -
getNameXPtg
Return an external name (named range, function, user-defined function) Ptg -
get3DReferencePtg
Produce the appropriate Ptg for a 3d cell reference -
get3DReferencePtg
Produce the appropriate Ptg for a 3d area reference -
getExternalSheetIndex
gets the externSheet index for a sheet from this workbook -
getExternalSheetIndex
gets the externSheet index for a sheet from an external workbook- Parameters:
workbookName
- e.g. "Budget.xls"sheetName
- a name of a sheet in that workbook
-
getSpreadsheetVersion
SpreadsheetVersion getSpreadsheetVersion()Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)
-