Interface FormulaParsingWorkbook

    • Method Detail

      • getName

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

        Name createName()
        Return the underlying workbook
      • getTable

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

        Ptg getNameXPtg​(java.lang.String name,
                        SheetIdentifier sheet)
        Return an external name (named range, function, user-defined function) Ptg
      • getExternalSheetIndex

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

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