Interface STable

    • Method Detail

      • getBook

        SBook getBook()
      • getAutoFilter

        SAutoFilter getAutoFilter()
        Gets the auto filter information if there is.
        Returns:
        the auto filter, or null if not found
      • enableAutoFilter

        void enableAutoFilter​(boolean enable)
      • createAutoFilter

        SAutoFilter createAutoFilter()
        Creates a new auto filter for this table the old one will be drop directly.
        Returns:
        the new auto filter.
      • deleteAutoFilter

        void deleteAutoFilter()
        Delete current autofilter if it has
      • getTotalsRowCount

        int getTotalsRowCount()
        Specified by:
        getTotalsRowCount in interface Table
        Returns:
        0 for no totals rows, 1 for totals row shown. Values > 1 are not currently used by Excel up through 2016, and the OOXML spec doesn't define how they would be implemented.
      • setTotalsRowCount

        void setTotalsRowCount​(int count)
      • getHeaderRowCount

        int getHeaderRowCount()
        Specified by:
        getHeaderRowCount in interface Table
        Returns:
        0 for no header rows, 1 for table headers shown. Values > 1 might be used by Excel for pivot tables?
      • setHeaderRowCount

        void setHeaderRowCount​(int count)
      • getName

        String getName()
        Description copied from interface: Table
        Get the name of the table.
        Specified by:
        getName in interface Table
        Returns:
        table name
      • setName

        void setName​(String name)
      • getDisplayName

        String getDisplayName()
      • setDisplayName

        void setDisplayName​(String name)
      • getThisRowRegion

        SheetRegion getThisRowRegion​(int rowIdx)