Interface CTMacrosheet

  • All Superinterfaces:
    XmlObject, XmlTokenSource

    public interface CTMacrosheet
    extends XmlObject
    An XML CT_Macrosheet(@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

        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
      • 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
      • 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
      • 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

        List<CTConditionalFormatting> getConditionalFormattingList()
        Gets a List of "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
      • 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
      • 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
      • 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