Interface CTWorksheet

  • All Superinterfaces:
    XmlObject, XmlTokenSource

    public interface CTWorksheet
    extends XmlObject
    An XML CT_Worksheet(@http://schemas.openxmlformats.org/spreadsheetml/2006/main). This is a complex type.
    • Method Detail

      • getSheetPr

        CTSheetPr getSheetPr()
        Gets the "sheetPr" element
      • isSetSheetPr

        boolean isSetSheetPr()
        True if has "sheetPr" element
      • setSheetPr

        void setSheetPr​(CTSheetPr sheetPr)
        Sets the "sheetPr" element
      • addNewSheetPr

        CTSheetPr addNewSheetPr()
        Appends and returns a new empty "sheetPr" element
      • unsetSheetPr

        void unsetSheetPr()
        Unsets the "sheetPr" element
      • isSetDimension

        boolean isSetDimension()
        True if has "dimension" element
      • setDimension

        void setDimension​(CTSheetDimension dimension)
        Sets the "dimension" element
      • addNewDimension

        CTSheetDimension addNewDimension()
        Appends and returns a new empty "dimension" element
      • unsetDimension

        void unsetDimension()
        Unsets the "dimension" element
      • getSheetViews

        CTSheetViews getSheetViews()
        Gets the "sheetViews" element
      • isSetSheetViews

        boolean isSetSheetViews()
        True if has "sheetViews" element
      • setSheetViews

        void setSheetViews​(CTSheetViews sheetViews)
        Sets the "sheetViews" element
      • addNewSheetViews

        CTSheetViews addNewSheetViews()
        Appends and returns a new empty "sheetViews" element
      • unsetSheetViews

        void unsetSheetViews()
        Unsets the "sheetViews" element
      • getSheetFormatPr

        CTSheetFormatPr getSheetFormatPr()
        Gets the "sheetFormatPr" element
      • isSetSheetFormatPr

        boolean isSetSheetFormatPr()
        True if has "sheetFormatPr" element
      • setSheetFormatPr

        void setSheetFormatPr​(CTSheetFormatPr sheetFormatPr)
        Sets the "sheetFormatPr" element
      • addNewSheetFormatPr

        CTSheetFormatPr addNewSheetFormatPr()
        Appends and returns a new empty "sheetFormatPr" element
      • unsetSheetFormatPr

        void unsetSheetFormatPr()
        Unsets the "sheetFormatPr" element
      • getColsList

        java.util.List<CTCols> getColsList()
        Gets a List of "cols" elements
      • getColsArray

        @Deprecated
        CTCols[] getColsArray()
        Deprecated.
        Gets array of all "cols" elements
      • getColsArray

        CTCols getColsArray​(int i)
        Gets ith "cols" element
      • sizeOfColsArray

        int sizeOfColsArray()
        Returns number of "cols" element
      • setColsArray

        void setColsArray​(CTCols[] colsArray)
        Sets array of all "cols" element
      • setColsArray

        void setColsArray​(int i,
                          CTCols cols)
        Sets ith "cols" element
      • insertNewCols

        CTCols insertNewCols​(int i)
        Inserts and returns a new empty value (as xml) as the ith "cols" element
      • addNewCols

        CTCols addNewCols()
        Appends and returns a new empty value (as xml) as the last "cols" element
      • removeCols

        void removeCols​(int i)
        Removes the ith "cols" element
      • getSheetData

        CTSheetData getSheetData()
        Gets the "sheetData" element
      • setSheetData

        void setSheetData​(CTSheetData sheetData)
        Sets the "sheetData" element
      • addNewSheetData

        CTSheetData addNewSheetData()
        Appends and returns a new empty "sheetData" element
      • getSheetCalcPr

        CTSheetCalcPr getSheetCalcPr()
        Gets the "sheetCalcPr" element
      • isSetSheetCalcPr

        boolean isSetSheetCalcPr()
        True if has "sheetCalcPr" element
      • setSheetCalcPr

        void setSheetCalcPr​(CTSheetCalcPr sheetCalcPr)
        Sets the "sheetCalcPr" element
      • addNewSheetCalcPr

        CTSheetCalcPr addNewSheetCalcPr()
        Appends and returns a new empty "sheetCalcPr" element
      • unsetSheetCalcPr

        void unsetSheetCalcPr()
        Unsets the "sheetCalcPr" element
      • getSheetProtection

        CTSheetProtection getSheetProtection()
        Gets the "sheetProtection" element
      • isSetSheetProtection

        boolean isSetSheetProtection()
        True if has "sheetProtection" element
      • setSheetProtection

        void setSheetProtection​(CTSheetProtection sheetProtection)
        Sets the "sheetProtection" element
      • addNewSheetProtection

        CTSheetProtection addNewSheetProtection()
        Appends and returns a new empty "sheetProtection" element
      • unsetSheetProtection

        void unsetSheetProtection()
        Unsets the "sheetProtection" element
      • getProtectedRanges

        CTProtectedRanges getProtectedRanges()
        Gets the "protectedRanges" element
      • isSetProtectedRanges

        boolean isSetProtectedRanges()
        True if has "protectedRanges" element
      • setProtectedRanges

        void setProtectedRanges​(CTProtectedRanges protectedRanges)
        Sets the "protectedRanges" element
      • addNewProtectedRanges

        CTProtectedRanges addNewProtectedRanges()
        Appends and returns a new empty "protectedRanges" element
      • unsetProtectedRanges

        void unsetProtectedRanges()
        Unsets the "protectedRanges" element
      • getScenarios

        CTScenarios getScenarios()
        Gets the "scenarios" element
      • isSetScenarios

        boolean isSetScenarios()
        True if has "scenarios" element
      • setScenarios

        void setScenarios​(CTScenarios scenarios)
        Sets the "scenarios" element
      • addNewScenarios

        CTScenarios addNewScenarios()
        Appends and returns a new empty "scenarios" element
      • unsetScenarios

        void unsetScenarios()
        Unsets the "scenarios" element
      • getAutoFilter

        CTAutoFilter getAutoFilter()
        Gets the "autoFilter" element
      • isSetAutoFilter

        boolean isSetAutoFilter()
        True if has "autoFilter" element
      • setAutoFilter

        void setAutoFilter​(CTAutoFilter autoFilter)
        Sets the "autoFilter" element
      • addNewAutoFilter

        CTAutoFilter addNewAutoFilter()
        Appends and returns a new empty "autoFilter" element
      • unsetAutoFilter

        void unsetAutoFilter()
        Unsets the "autoFilter" element
      • getSortState

        CTSortState getSortState()
        Gets the "sortState" element
      • isSetSortState

        boolean isSetSortState()
        True if has "sortState" element
      • setSortState

        void setSortState​(CTSortState sortState)
        Sets the "sortState" element
      • addNewSortState

        CTSortState addNewSortState()
        Appends and returns a new empty "sortState" element
      • unsetSortState

        void unsetSortState()
        Unsets the "sortState" element
      • getDataConsolidate

        CTDataConsolidate getDataConsolidate()
        Gets the "dataConsolidate" element
      • isSetDataConsolidate

        boolean isSetDataConsolidate()
        True if has "dataConsolidate" element
      • setDataConsolidate

        void setDataConsolidate​(CTDataConsolidate dataConsolidate)
        Sets the "dataConsolidate" element
      • addNewDataConsolidate

        CTDataConsolidate addNewDataConsolidate()
        Appends and returns a new empty "dataConsolidate" element
      • unsetDataConsolidate

        void unsetDataConsolidate()
        Unsets the "dataConsolidate" element
      • getCustomSheetViews

        CTCustomSheetViews getCustomSheetViews()
        Gets the "customSheetViews" element
      • isSetCustomSheetViews

        boolean isSetCustomSheetViews()
        True if has "customSheetViews" element
      • setCustomSheetViews

        void setCustomSheetViews​(CTCustomSheetViews customSheetViews)
        Sets the "customSheetViews" element
      • addNewCustomSheetViews

        CTCustomSheetViews addNewCustomSheetViews()
        Appends and returns a new empty "customSheetViews" element
      • unsetCustomSheetViews

        void unsetCustomSheetViews()
        Unsets the "customSheetViews" element
      • getMergeCells

        CTMergeCells getMergeCells()
        Gets the "mergeCells" element
      • isSetMergeCells

        boolean isSetMergeCells()
        True if has "mergeCells" element
      • setMergeCells

        void setMergeCells​(CTMergeCells mergeCells)
        Sets the "mergeCells" element
      • addNewMergeCells

        CTMergeCells addNewMergeCells()
        Appends and returns a new empty "mergeCells" element
      • unsetMergeCells

        void unsetMergeCells()
        Unsets the "mergeCells" element
      • getPhoneticPr

        CTPhoneticPr getPhoneticPr()
        Gets the "phoneticPr" element
      • isSetPhoneticPr

        boolean isSetPhoneticPr()
        True if has "phoneticPr" element
      • setPhoneticPr

        void setPhoneticPr​(CTPhoneticPr phoneticPr)
        Sets the "phoneticPr" element
      • addNewPhoneticPr

        CTPhoneticPr addNewPhoneticPr()
        Appends and returns a new empty "phoneticPr" element
      • unsetPhoneticPr

        void unsetPhoneticPr()
        Unsets the "phoneticPr" element
      • getConditionalFormattingList

        java.util.List<CTConditionalFormatting> getConditionalFormattingList()
        Gets a List of "conditionalFormatting" elements
      • getConditionalFormattingArray

        @Deprecated
        CTConditionalFormatting[] getConditionalFormattingArray()
        Deprecated.
        Gets array of all "conditionalFormatting" elements
      • getConditionalFormattingArray

        CTConditionalFormatting getConditionalFormattingArray​(int i)
        Gets ith "conditionalFormatting" element
      • sizeOfConditionalFormattingArray

        int sizeOfConditionalFormattingArray()
        Returns number of "conditionalFormatting" element
      • setConditionalFormattingArray

        void setConditionalFormattingArray​(CTConditionalFormatting[] conditionalFormattingArray)
        Sets array of all "conditionalFormatting" element
      • setConditionalFormattingArray

        void setConditionalFormattingArray​(int i,
                                           CTConditionalFormatting conditionalFormatting)
        Sets ith "conditionalFormatting" element
      • insertNewConditionalFormatting

        CTConditionalFormatting insertNewConditionalFormatting​(int i)
        Inserts and returns a new empty value (as xml) as the ith "conditionalFormatting" element
      • addNewConditionalFormatting

        CTConditionalFormatting addNewConditionalFormatting()
        Appends and returns a new empty value (as xml) as the last "conditionalFormatting" element
      • removeConditionalFormatting

        void removeConditionalFormatting​(int i)
        Removes the ith "conditionalFormatting" element
      • getDataValidations

        CTDataValidations getDataValidations()
        Gets the "dataValidations" element
      • isSetDataValidations

        boolean isSetDataValidations()
        True if has "dataValidations" element
      • setDataValidations

        void setDataValidations​(CTDataValidations dataValidations)
        Sets the "dataValidations" element
      • addNewDataValidations

        CTDataValidations addNewDataValidations()
        Appends and returns a new empty "dataValidations" element
      • unsetDataValidations

        void unsetDataValidations()
        Unsets the "dataValidations" element
      • getHyperlinks

        CTHyperlinks getHyperlinks()
        Gets the "hyperlinks" element
      • isSetHyperlinks

        boolean isSetHyperlinks()
        True if has "hyperlinks" element
      • setHyperlinks

        void setHyperlinks​(CTHyperlinks hyperlinks)
        Sets the "hyperlinks" element
      • addNewHyperlinks

        CTHyperlinks addNewHyperlinks()
        Appends and returns a new empty "hyperlinks" element
      • unsetHyperlinks

        void unsetHyperlinks()
        Unsets the "hyperlinks" element
      • getPrintOptions

        CTPrintOptions getPrintOptions()
        Gets the "printOptions" element
      • isSetPrintOptions

        boolean isSetPrintOptions()
        True if has "printOptions" element
      • setPrintOptions

        void setPrintOptions​(CTPrintOptions printOptions)
        Sets the "printOptions" element
      • addNewPrintOptions

        CTPrintOptions addNewPrintOptions()
        Appends and returns a new empty "printOptions" element
      • unsetPrintOptions

        void unsetPrintOptions()
        Unsets the "printOptions" element
      • getPageMargins

        CTPageMargins getPageMargins()
        Gets the "pageMargins" element
      • isSetPageMargins

        boolean isSetPageMargins()
        True if has "pageMargins" element
      • setPageMargins

        void setPageMargins​(CTPageMargins pageMargins)
        Sets the "pageMargins" element
      • addNewPageMargins

        CTPageMargins addNewPageMargins()
        Appends and returns a new empty "pageMargins" element
      • unsetPageMargins

        void unsetPageMargins()
        Unsets the "pageMargins" element
      • getPageSetup

        CTPageSetup getPageSetup()
        Gets the "pageSetup" element
      • isSetPageSetup

        boolean isSetPageSetup()
        True if has "pageSetup" element
      • setPageSetup

        void setPageSetup​(CTPageSetup pageSetup)
        Sets the "pageSetup" element
      • addNewPageSetup

        CTPageSetup addNewPageSetup()
        Appends and returns a new empty "pageSetup" element
      • unsetPageSetup

        void unsetPageSetup()
        Unsets the "pageSetup" element
      • getHeaderFooter

        CTHeaderFooter getHeaderFooter()
        Gets the "headerFooter" element
      • isSetHeaderFooter

        boolean isSetHeaderFooter()
        True if has "headerFooter" element
      • setHeaderFooter

        void setHeaderFooter​(CTHeaderFooter headerFooter)
        Sets the "headerFooter" element
      • addNewHeaderFooter

        CTHeaderFooter addNewHeaderFooter()
        Appends and returns a new empty "headerFooter" element
      • unsetHeaderFooter

        void unsetHeaderFooter()
        Unsets the "headerFooter" element
      • getRowBreaks

        CTPageBreak getRowBreaks()
        Gets the "rowBreaks" element
      • isSetRowBreaks

        boolean isSetRowBreaks()
        True if has "rowBreaks" element
      • setRowBreaks

        void setRowBreaks​(CTPageBreak rowBreaks)
        Sets the "rowBreaks" element
      • addNewRowBreaks

        CTPageBreak addNewRowBreaks()
        Appends and returns a new empty "rowBreaks" element
      • unsetRowBreaks

        void unsetRowBreaks()
        Unsets the "rowBreaks" element
      • getColBreaks

        CTPageBreak getColBreaks()
        Gets the "colBreaks" element
      • isSetColBreaks

        boolean isSetColBreaks()
        True if has "colBreaks" element
      • setColBreaks

        void setColBreaks​(CTPageBreak colBreaks)
        Sets the "colBreaks" element
      • addNewColBreaks

        CTPageBreak addNewColBreaks()
        Appends and returns a new empty "colBreaks" element
      • unsetColBreaks

        void unsetColBreaks()
        Unsets the "colBreaks" element
      • getCustomProperties

        CTCustomProperties getCustomProperties()
        Gets the "customProperties" element
      • isSetCustomProperties

        boolean isSetCustomProperties()
        True if has "customProperties" element
      • setCustomProperties

        void setCustomProperties​(CTCustomProperties customProperties)
        Sets the "customProperties" element
      • addNewCustomProperties

        CTCustomProperties addNewCustomProperties()
        Appends and returns a new empty "customProperties" element
      • unsetCustomProperties

        void unsetCustomProperties()
        Unsets the "customProperties" element
      • getCellWatches

        CTCellWatches getCellWatches()
        Gets the "cellWatches" element
      • isSetCellWatches

        boolean isSetCellWatches()
        True if has "cellWatches" element
      • setCellWatches

        void setCellWatches​(CTCellWatches cellWatches)
        Sets the "cellWatches" element
      • addNewCellWatches

        CTCellWatches addNewCellWatches()
        Appends and returns a new empty "cellWatches" element
      • unsetCellWatches

        void unsetCellWatches()
        Unsets the "cellWatches" element
      • getIgnoredErrors

        CTIgnoredErrors getIgnoredErrors()
        Gets the "ignoredErrors" element
      • isSetIgnoredErrors

        boolean isSetIgnoredErrors()
        True if has "ignoredErrors" element
      • setIgnoredErrors

        void setIgnoredErrors​(CTIgnoredErrors ignoredErrors)
        Sets the "ignoredErrors" element
      • addNewIgnoredErrors

        CTIgnoredErrors addNewIgnoredErrors()
        Appends and returns a new empty "ignoredErrors" element
      • unsetIgnoredErrors

        void unsetIgnoredErrors()
        Unsets the "ignoredErrors" element
      • getSmartTags

        CTSmartTags getSmartTags()
        Gets the "smartTags" element
      • isSetSmartTags

        boolean isSetSmartTags()
        True if has "smartTags" element
      • setSmartTags

        void setSmartTags​(CTSmartTags smartTags)
        Sets the "smartTags" element
      • addNewSmartTags

        CTSmartTags addNewSmartTags()
        Appends and returns a new empty "smartTags" element
      • unsetSmartTags

        void unsetSmartTags()
        Unsets the "smartTags" element
      • getDrawing

        CTDrawing getDrawing()
        Gets the "drawing" element
      • isSetDrawing

        boolean isSetDrawing()
        True if has "drawing" element
      • setDrawing

        void setDrawing​(CTDrawing drawing)
        Sets the "drawing" element
      • addNewDrawing

        CTDrawing addNewDrawing()
        Appends and returns a new empty "drawing" element
      • unsetDrawing

        void unsetDrawing()
        Unsets the "drawing" element
      • getLegacyDrawing

        CTLegacyDrawing getLegacyDrawing()
        Gets the "legacyDrawing" element
      • isSetLegacyDrawing

        boolean isSetLegacyDrawing()
        True if has "legacyDrawing" element
      • setLegacyDrawing

        void setLegacyDrawing​(CTLegacyDrawing legacyDrawing)
        Sets the "legacyDrawing" element
      • addNewLegacyDrawing

        CTLegacyDrawing addNewLegacyDrawing()
        Appends and returns a new empty "legacyDrawing" element
      • unsetLegacyDrawing

        void unsetLegacyDrawing()
        Unsets the "legacyDrawing" element
      • getLegacyDrawingHF

        CTLegacyDrawing getLegacyDrawingHF()
        Gets the "legacyDrawingHF" element
      • isSetLegacyDrawingHF

        boolean isSetLegacyDrawingHF()
        True if has "legacyDrawingHF" element
      • setLegacyDrawingHF

        void setLegacyDrawingHF​(CTLegacyDrawing legacyDrawingHF)
        Sets the "legacyDrawingHF" element
      • addNewLegacyDrawingHF

        CTLegacyDrawing addNewLegacyDrawingHF()
        Appends and returns a new empty "legacyDrawingHF" element
      • unsetLegacyDrawingHF

        void unsetLegacyDrawingHF()
        Unsets the "legacyDrawingHF" element
      • isSetPicture

        boolean isSetPicture()
        True if has "picture" element
      • unsetPicture

        void unsetPicture()
        Unsets the "picture" element
      • getOleObjects

        CTOleObjects getOleObjects()
        Gets the "oleObjects" element
      • isSetOleObjects

        boolean isSetOleObjects()
        True if has "oleObjects" element
      • setOleObjects

        void setOleObjects​(CTOleObjects oleObjects)
        Sets the "oleObjects" element
      • addNewOleObjects

        CTOleObjects addNewOleObjects()
        Appends and returns a new empty "oleObjects" element
      • unsetOleObjects

        void unsetOleObjects()
        Unsets the "oleObjects" element
      • getControls

        CTControls getControls()
        Gets the "controls" element
      • isSetControls

        boolean isSetControls()
        True if has "controls" element
      • setControls

        void setControls​(CTControls controls)
        Sets the "controls" element
      • addNewControls

        CTControls addNewControls()
        Appends and returns a new empty "controls" element
      • unsetControls

        void unsetControls()
        Unsets the "controls" element
      • getWebPublishItems

        CTWebPublishItems getWebPublishItems()
        Gets the "webPublishItems" element
      • isSetWebPublishItems

        boolean isSetWebPublishItems()
        True if has "webPublishItems" element
      • setWebPublishItems

        void setWebPublishItems​(CTWebPublishItems webPublishItems)
        Sets the "webPublishItems" element
      • addNewWebPublishItems

        CTWebPublishItems addNewWebPublishItems()
        Appends and returns a new empty "webPublishItems" element
      • unsetWebPublishItems

        void unsetWebPublishItems()
        Unsets the "webPublishItems" element
      • getTableParts

        CTTableParts getTableParts()
        Gets the "tableParts" element
      • isSetTableParts

        boolean isSetTableParts()
        True if has "tableParts" element
      • setTableParts

        void setTableParts​(CTTableParts tableParts)
        Sets the "tableParts" element
      • addNewTableParts

        CTTableParts addNewTableParts()
        Appends and returns a new empty "tableParts" element
      • unsetTableParts

        void unsetTableParts()
        Unsets the "tableParts" element
      • isSetExtLst

        boolean isSetExtLst()
        True if has "extLst" element
      • setExtLst

        void setExtLst​(CTExtensionList extLst)
        Sets the "extLst" element
      • addNewExtLst

        CTExtensionList addNewExtLst()
        Appends and returns a new empty "extLst" element
      • unsetExtLst

        void unsetExtLst()
        Unsets the "extLst" element