Package org.openxmlformats.schemas.spreadsheetml.x2006.main

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