public interface CTMacrosheet extends XmlObject
Modifier and Type | Interface and Description |
---|---|
static class |
CTMacrosheet.Factory
A factory class with static methods for creating instances
of this type.
|
Modifier and Type | Field and Description |
---|---|
static SchemaType |
type |
EQUAL, GREATER_THAN, LESS_THAN, NOT_EQUAL
Modifier and Type | Method and Description |
---|---|
CTAutoFilter |
addNewAutoFilter()
Appends and returns a new empty "autoFilter" element
|
CTPageBreak |
addNewColBreaks()
Appends and returns a new empty "colBreaks" element
|
CTCols |
addNewCols()
Appends and returns a new empty value (as xml) as the last "cols" element
|
CTConditionalFormatting |
addNewConditionalFormatting()
Appends and returns a new empty value (as xml) as the last "conditionalFormatting" element
|
CTCustomProperties |
addNewCustomProperties()
Appends and returns a new empty "customProperties" element
|
CTCustomSheetViews |
addNewCustomSheetViews()
Appends and returns a new empty "customSheetViews" element
|
CTDataConsolidate |
addNewDataConsolidate()
Appends and returns a new empty "dataConsolidate" element
|
CTSheetDimension |
addNewDimension()
Appends and returns a new empty "dimension" element
|
CTDrawing |
addNewDrawing()
Appends and returns a new empty "drawing" element
|
CTExtensionList |
addNewExtLst()
Appends and returns a new empty "extLst" element
|
CTHeaderFooter |
addNewHeaderFooter()
Appends and returns a new empty "headerFooter" element
|
CTLegacyDrawing |
addNewLegacyDrawing()
Appends and returns a new empty "legacyDrawing" element
|
CTLegacyDrawing |
addNewLegacyDrawingHF()
Appends and returns a new empty "legacyDrawingHF" element
|
CTOleObjects |
addNewOleObjects()
Appends and returns a new empty "oleObjects" element
|
CTPageMargins |
addNewPageMargins()
Appends and returns a new empty "pageMargins" element
|
CTPageSetup |
addNewPageSetup()
Appends and returns a new empty "pageSetup" element
|
CTPhoneticPr |
addNewPhoneticPr()
Appends and returns a new empty "phoneticPr" element
|
CTSheetBackgroundPicture |
addNewPicture()
Appends and returns a new empty "picture" element
|
CTPrintOptions |
addNewPrintOptions()
Appends and returns a new empty "printOptions" element
|
CTPageBreak |
addNewRowBreaks()
Appends and returns a new empty "rowBreaks" element
|
CTSheetData |
addNewSheetData()
Appends and returns a new empty "sheetData" element
|
CTSheetFormatPr |
addNewSheetFormatPr()
Appends and returns a new empty "sheetFormatPr" element
|
CTSheetPr |
addNewSheetPr()
Appends and returns a new empty "sheetPr" element
|
CTSheetProtection |
addNewSheetProtection()
Appends and returns a new empty "sheetProtection" element
|
CTSheetViews |
addNewSheetViews()
Appends and returns a new empty "sheetViews" element
|
CTSortState |
addNewSortState()
Appends and returns a new empty "sortState" element
|
CTAutoFilter |
getAutoFilter()
Gets the "autoFilter" element
|
CTPageBreak |
getColBreaks()
Gets the "colBreaks" element
|
CTCols[] |
getColsArray()
Deprecated.
|
CTCols |
getColsArray(int i)
Gets ith "cols" element
|
List<CTCols> |
getColsList()
Gets a List of "cols" elements
|
CTConditionalFormatting[] |
getConditionalFormattingArray()
Deprecated.
|
CTConditionalFormatting |
getConditionalFormattingArray(int i)
Gets ith "conditionalFormatting" element
|
List<CTConditionalFormatting> |
getConditionalFormattingList()
Gets a List of "conditionalFormatting" elements
|
CTCustomProperties |
getCustomProperties()
Gets the "customProperties" element
|
CTCustomSheetViews |
getCustomSheetViews()
Gets the "customSheetViews" element
|
CTDataConsolidate |
getDataConsolidate()
Gets the "dataConsolidate" element
|
CTSheetDimension |
getDimension()
Gets the "dimension" element
|
CTDrawing |
getDrawing()
Gets the "drawing" element
|
CTExtensionList |
getExtLst()
Gets the "extLst" element
|
CTHeaderFooter |
getHeaderFooter()
Gets the "headerFooter" element
|
CTLegacyDrawing |
getLegacyDrawing()
Gets the "legacyDrawing" element
|
CTLegacyDrawing |
getLegacyDrawingHF()
Gets the "legacyDrawingHF" element
|
CTOleObjects |
getOleObjects()
Gets the "oleObjects" element
|
CTPageMargins |
getPageMargins()
Gets the "pageMargins" element
|
CTPageSetup |
getPageSetup()
Gets the "pageSetup" element
|
CTPhoneticPr |
getPhoneticPr()
Gets the "phoneticPr" element
|
CTSheetBackgroundPicture |
getPicture()
Gets the "picture" element
|
CTPrintOptions |
getPrintOptions()
Gets the "printOptions" element
|
CTPageBreak |
getRowBreaks()
Gets the "rowBreaks" element
|
CTSheetData |
getSheetData()
Gets the "sheetData" element
|
CTSheetFormatPr |
getSheetFormatPr()
Gets the "sheetFormatPr" element
|
CTSheetPr |
getSheetPr()
Gets the "sheetPr" element
|
CTSheetProtection |
getSheetProtection()
Gets the "sheetProtection" element
|
CTSheetViews |
getSheetViews()
Gets the "sheetViews" element
|
CTSortState |
getSortState()
Gets the "sortState" element
|
CTCols |
insertNewCols(int i)
Inserts and returns a new empty value (as xml) as the ith "cols" element
|
CTConditionalFormatting |
insertNewConditionalFormatting(int i)
Inserts and returns a new empty value (as xml) as the ith "conditionalFormatting" element
|
boolean |
isSetAutoFilter()
True if has "autoFilter" element
|
boolean |
isSetColBreaks()
True if has "colBreaks" element
|
boolean |
isSetCustomProperties()
True if has "customProperties" element
|
boolean |
isSetCustomSheetViews()
True if has "customSheetViews" element
|
boolean |
isSetDataConsolidate()
True if has "dataConsolidate" element
|
boolean |
isSetDimension()
True if has "dimension" element
|
boolean |
isSetDrawing()
True if has "drawing" element
|
boolean |
isSetExtLst()
True if has "extLst" element
|
boolean |
isSetHeaderFooter()
True if has "headerFooter" element
|
boolean |
isSetLegacyDrawing()
True if has "legacyDrawing" element
|
boolean |
isSetLegacyDrawingHF()
True if has "legacyDrawingHF" element
|
boolean |
isSetOleObjects()
True if has "oleObjects" element
|
boolean |
isSetPageMargins()
True if has "pageMargins" element
|
boolean |
isSetPageSetup()
True if has "pageSetup" element
|
boolean |
isSetPhoneticPr()
True if has "phoneticPr" element
|
boolean |
isSetPicture()
True if has "picture" element
|
boolean |
isSetPrintOptions()
True if has "printOptions" element
|
boolean |
isSetRowBreaks()
True if has "rowBreaks" element
|
boolean |
isSetSheetFormatPr()
True if has "sheetFormatPr" element
|
boolean |
isSetSheetPr()
True if has "sheetPr" element
|
boolean |
isSetSheetProtection()
True if has "sheetProtection" element
|
boolean |
isSetSheetViews()
True if has "sheetViews" element
|
boolean |
isSetSortState()
True if has "sortState" element
|
void |
removeCols(int i)
Removes the ith "cols" element
|
void |
removeConditionalFormatting(int i)
Removes the ith "conditionalFormatting" element
|
void |
setAutoFilter(CTAutoFilter autoFilter)
Sets the "autoFilter" element
|
void |
setColBreaks(CTPageBreak colBreaks)
Sets the "colBreaks" element
|
void |
setColsArray(CTCols[] colsArray)
Sets array of all "cols" element
|
void |
setColsArray(int i,
CTCols cols)
Sets ith "cols" element
|
void |
setConditionalFormattingArray(CTConditionalFormatting[] conditionalFormattingArray)
Sets array of all "conditionalFormatting" element
|
void |
setConditionalFormattingArray(int i,
CTConditionalFormatting conditionalFormatting)
Sets ith "conditionalFormatting" element
|
void |
setCustomProperties(CTCustomProperties customProperties)
Sets the "customProperties" element
|
void |
setCustomSheetViews(CTCustomSheetViews customSheetViews)
Sets the "customSheetViews" element
|
void |
setDataConsolidate(CTDataConsolidate dataConsolidate)
Sets the "dataConsolidate" element
|
void |
setDimension(CTSheetDimension dimension)
Sets the "dimension" element
|
void |
setDrawing(CTDrawing drawing)
Sets the "drawing" element
|
void |
setExtLst(CTExtensionList extLst)
Sets the "extLst" element
|
void |
setHeaderFooter(CTHeaderFooter headerFooter)
Sets the "headerFooter" element
|
void |
setLegacyDrawing(CTLegacyDrawing legacyDrawing)
Sets the "legacyDrawing" element
|
void |
setLegacyDrawingHF(CTLegacyDrawing legacyDrawingHF)
Sets the "legacyDrawingHF" element
|
void |
setOleObjects(CTOleObjects oleObjects)
Sets the "oleObjects" element
|
void |
setPageMargins(CTPageMargins pageMargins)
Sets the "pageMargins" element
|
void |
setPageSetup(CTPageSetup pageSetup)
Sets the "pageSetup" element
|
void |
setPhoneticPr(CTPhoneticPr phoneticPr)
Sets the "phoneticPr" element
|
void |
setPicture(CTSheetBackgroundPicture picture)
Sets the "picture" element
|
void |
setPrintOptions(CTPrintOptions printOptions)
Sets the "printOptions" element
|
void |
setRowBreaks(CTPageBreak rowBreaks)
Sets the "rowBreaks" element
|
void |
setSheetData(CTSheetData sheetData)
Sets the "sheetData" element
|
void |
setSheetFormatPr(CTSheetFormatPr sheetFormatPr)
Sets the "sheetFormatPr" element
|
void |
setSheetPr(CTSheetPr sheetPr)
Sets the "sheetPr" element
|
void |
setSheetProtection(CTSheetProtection sheetProtection)
Sets the "sheetProtection" element
|
void |
setSheetViews(CTSheetViews sheetViews)
Sets the "sheetViews" element
|
void |
setSortState(CTSortState sortState)
Sets the "sortState" element
|
int |
sizeOfColsArray()
Returns number of "cols" element
|
int |
sizeOfConditionalFormattingArray()
Returns number of "conditionalFormatting" element
|
void |
unsetAutoFilter()
Unsets the "autoFilter" element
|
void |
unsetColBreaks()
Unsets the "colBreaks" element
|
void |
unsetCustomProperties()
Unsets the "customProperties" element
|
void |
unsetCustomSheetViews()
Unsets the "customSheetViews" element
|
void |
unsetDataConsolidate()
Unsets the "dataConsolidate" element
|
void |
unsetDimension()
Unsets the "dimension" element
|
void |
unsetDrawing()
Unsets the "drawing" element
|
void |
unsetExtLst()
Unsets the "extLst" element
|
void |
unsetHeaderFooter()
Unsets the "headerFooter" element
|
void |
unsetLegacyDrawing()
Unsets the "legacyDrawing" element
|
void |
unsetLegacyDrawingHF()
Unsets the "legacyDrawingHF" element
|
void |
unsetOleObjects()
Unsets the "oleObjects" element
|
void |
unsetPageMargins()
Unsets the "pageMargins" element
|
void |
unsetPageSetup()
Unsets the "pageSetup" element
|
void |
unsetPhoneticPr()
Unsets the "phoneticPr" element
|
void |
unsetPicture()
Unsets the "picture" element
|
void |
unsetPrintOptions()
Unsets the "printOptions" element
|
void |
unsetRowBreaks()
Unsets the "rowBreaks" element
|
void |
unsetSheetFormatPr()
Unsets the "sheetFormatPr" element
|
void |
unsetSheetPr()
Unsets the "sheetPr" element
|
void |
unsetSheetProtection()
Unsets the "sheetProtection" element
|
void |
unsetSheetViews()
Unsets the "sheetViews" element
|
void |
unsetSortState()
Unsets the "sortState" element
|
changeType, compareTo, compareValue, copy, copy, execQuery, execQuery, isImmutable, isNil, schemaType, selectAttribute, selectAttribute, selectAttributes, selectChildren, selectChildren, selectChildren, selectPath, selectPath, set, setNil, substitute, toString, validate, validate, valueEquals, valueHashCode
documentProperties, dump, getDomNode, monitor, newCursor, newDomNode, newDomNode, newInputStream, newInputStream, newReader, newReader, newXMLInputStream, newXMLInputStream, newXMLStreamReader, newXMLStreamReader, save, save, save, save, save, save, save, save, xmlText, xmlText
static final SchemaType type
CTSheetPr getSheetPr()
boolean isSetSheetPr()
void setSheetPr(CTSheetPr sheetPr)
CTSheetPr addNewSheetPr()
void unsetSheetPr()
CTSheetDimension getDimension()
boolean isSetDimension()
void setDimension(CTSheetDimension dimension)
CTSheetDimension addNewDimension()
void unsetDimension()
CTSheetViews getSheetViews()
boolean isSetSheetViews()
void setSheetViews(CTSheetViews sheetViews)
CTSheetViews addNewSheetViews()
void unsetSheetViews()
CTSheetFormatPr getSheetFormatPr()
boolean isSetSheetFormatPr()
void setSheetFormatPr(CTSheetFormatPr sheetFormatPr)
CTSheetFormatPr addNewSheetFormatPr()
void unsetSheetFormatPr()
@Deprecated CTCols[] getColsArray()
CTCols getColsArray(int i)
int sizeOfColsArray()
void setColsArray(CTCols[] colsArray)
void setColsArray(int i, CTCols cols)
CTCols insertNewCols(int i)
CTCols addNewCols()
void removeCols(int i)
CTSheetData getSheetData()
void setSheetData(CTSheetData sheetData)
CTSheetData addNewSheetData()
CTSheetProtection getSheetProtection()
boolean isSetSheetProtection()
void setSheetProtection(CTSheetProtection sheetProtection)
CTSheetProtection addNewSheetProtection()
void unsetSheetProtection()
CTAutoFilter getAutoFilter()
boolean isSetAutoFilter()
void setAutoFilter(CTAutoFilter autoFilter)
CTAutoFilter addNewAutoFilter()
void unsetAutoFilter()
CTSortState getSortState()
boolean isSetSortState()
void setSortState(CTSortState sortState)
CTSortState addNewSortState()
void unsetSortState()
CTDataConsolidate getDataConsolidate()
boolean isSetDataConsolidate()
void setDataConsolidate(CTDataConsolidate dataConsolidate)
CTDataConsolidate addNewDataConsolidate()
void unsetDataConsolidate()
CTCustomSheetViews getCustomSheetViews()
boolean isSetCustomSheetViews()
void setCustomSheetViews(CTCustomSheetViews customSheetViews)
CTCustomSheetViews addNewCustomSheetViews()
void unsetCustomSheetViews()
CTPhoneticPr getPhoneticPr()
boolean isSetPhoneticPr()
void setPhoneticPr(CTPhoneticPr phoneticPr)
CTPhoneticPr addNewPhoneticPr()
void unsetPhoneticPr()
List<CTConditionalFormatting> getConditionalFormattingList()
@Deprecated CTConditionalFormatting[] getConditionalFormattingArray()
CTConditionalFormatting getConditionalFormattingArray(int i)
int sizeOfConditionalFormattingArray()
void setConditionalFormattingArray(CTConditionalFormatting[] conditionalFormattingArray)
void setConditionalFormattingArray(int i, CTConditionalFormatting conditionalFormatting)
CTConditionalFormatting insertNewConditionalFormatting(int i)
CTConditionalFormatting addNewConditionalFormatting()
void removeConditionalFormatting(int i)
CTPrintOptions getPrintOptions()
boolean isSetPrintOptions()
void setPrintOptions(CTPrintOptions printOptions)
CTPrintOptions addNewPrintOptions()
void unsetPrintOptions()
CTPageMargins getPageMargins()
boolean isSetPageMargins()
void setPageMargins(CTPageMargins pageMargins)
CTPageMargins addNewPageMargins()
void unsetPageMargins()
CTPageSetup getPageSetup()
boolean isSetPageSetup()
void setPageSetup(CTPageSetup pageSetup)
CTPageSetup addNewPageSetup()
void unsetPageSetup()
CTHeaderFooter getHeaderFooter()
boolean isSetHeaderFooter()
void setHeaderFooter(CTHeaderFooter headerFooter)
CTHeaderFooter addNewHeaderFooter()
void unsetHeaderFooter()
CTPageBreak getRowBreaks()
boolean isSetRowBreaks()
void setRowBreaks(CTPageBreak rowBreaks)
CTPageBreak addNewRowBreaks()
void unsetRowBreaks()
CTPageBreak getColBreaks()
boolean isSetColBreaks()
void setColBreaks(CTPageBreak colBreaks)
CTPageBreak addNewColBreaks()
void unsetColBreaks()
CTCustomProperties getCustomProperties()
boolean isSetCustomProperties()
void setCustomProperties(CTCustomProperties customProperties)
CTCustomProperties addNewCustomProperties()
void unsetCustomProperties()
CTDrawing getDrawing()
boolean isSetDrawing()
void setDrawing(CTDrawing drawing)
CTDrawing addNewDrawing()
void unsetDrawing()
CTLegacyDrawing getLegacyDrawing()
boolean isSetLegacyDrawing()
void setLegacyDrawing(CTLegacyDrawing legacyDrawing)
CTLegacyDrawing addNewLegacyDrawing()
void unsetLegacyDrawing()
CTLegacyDrawing getLegacyDrawingHF()
boolean isSetLegacyDrawingHF()
void setLegacyDrawingHF(CTLegacyDrawing legacyDrawingHF)
CTLegacyDrawing addNewLegacyDrawingHF()
void unsetLegacyDrawingHF()
CTSheetBackgroundPicture getPicture()
boolean isSetPicture()
void setPicture(CTSheetBackgroundPicture picture)
CTSheetBackgroundPicture addNewPicture()
void unsetPicture()
CTOleObjects getOleObjects()
boolean isSetOleObjects()
void setOleObjects(CTOleObjects oleObjects)
CTOleObjects addNewOleObjects()
void unsetOleObjects()
CTExtensionList getExtLst()
boolean isSetExtLst()
void setExtLst(CTExtensionList extLst)
CTExtensionList addNewExtLst()
void unsetExtLst()
Copyright © 2010 - 2020 Adobe. All Rights Reserved