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
Author:
Josh Micich
  • Method Details

    • getName

      EvaluationName getName(String name, int sheetIndex)
      named range name matching is case insensitive
    • createName

      Name createName()
      Return the underlying workbook
    • getTable

      Table getTable(String name)
      XSSF Only - gets a table that exists in the worksheet
    • getNameXPtg

      Ptg getNameXPtg(String name, SheetIdentifier sheet)
      Return an external name (named range, function, user-defined function) Ptg
    • get3DReferencePtg

      Ptg get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
      Produce the appropriate Ptg for a 3d cell reference
    • get3DReferencePtg

      Ptg get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
      Produce the appropriate Ptg for a 3d area reference
    • getExternalSheetIndex

      int getExternalSheetIndex(String sheetName)
      gets the externSheet index for a sheet from this workbook
    • getExternalSheetIndex

      int getExternalSheetIndex(String workbookName, String sheetName)
      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.)