Worksheet (docx4j 6.1.2 API)

java.lang.Object
- org.xlsx4j.sml.Worksheet

All Implemented Interfaces:: Child

public class Worksheet
extends Object
implements Child

Java class for CT_Worksheet complex type.

The following schema fragment specifies the expected content contained within this class.

 <complexType name="CT_Worksheet">
   <complexContent>
     <restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
       <sequence>
         <element name="sheetPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetPr" minOccurs="0"/>
         <element name="dimension" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetDimension" minOccurs="0"/>
         <element name="sheetViews" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetViews" minOccurs="0"/>
         <element name="sheetFormatPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetFormatPr" minOccurs="0"/>
         <element name="cols" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Cols" maxOccurs="unbounded" minOccurs="0"/>
         <element name="sheetData" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetData"/>
         <element name="sheetCalcPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetCalcPr" minOccurs="0"/>
         <element name="sheetProtection" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetProtection" minOccurs="0"/>
         <element name="protectedRanges" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ProtectedRanges" minOccurs="0"/>
         <element name="scenarios" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Scenarios" minOccurs="0"/>
         <element name="autoFilter" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_AutoFilter" minOccurs="0"/>
         <element name="sortState" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SortState" minOccurs="0"/>
         <element name="dataConsolidate" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DataConsolidate" minOccurs="0"/>
         <element name="customSheetViews" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CustomSheetViews" minOccurs="0"/>
         <element name="mergeCells" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_MergeCells" minOccurs="0"/>
         <element name="phoneticPr" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PhoneticPr" minOccurs="0"/>
         <element name="conditionalFormatting" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ConditionalFormatting" maxOccurs="unbounded" minOccurs="0"/>
         <element name="dataValidations" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DataValidations" minOccurs="0"/>
         <element name="hyperlinks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Hyperlinks" minOccurs="0"/>
         <element name="printOptions" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PrintOptions" minOccurs="0"/>
         <element name="pageMargins" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageMargins" minOccurs="0"/>
         <element name="pageSetup" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageSetup" minOccurs="0"/>
         <element name="headerFooter" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_HeaderFooter" minOccurs="0"/>
         <element name="rowBreaks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageBreak" minOccurs="0"/>
         <element name="colBreaks" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_PageBreak" minOccurs="0"/>
         <element name="customProperties" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CustomProperties" minOccurs="0"/>
         <element name="cellWatches" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_CellWatches" minOccurs="0"/>
         <element name="ignoredErrors" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_IgnoredErrors" minOccurs="0"/>
         <element name="smartTags" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SmartTags" minOccurs="0"/>
         <element name="drawing" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Drawing" minOccurs="0"/>
         <element name="legacyDrawing" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_LegacyDrawing" minOccurs="0"/>
         <element name="legacyDrawingHF" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_LegacyDrawing" minOccurs="0"/>
         <element name="drawingHF" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_DrawingHF" minOccurs="0"/>
         <element name="picture" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_SheetBackgroundPicture" minOccurs="0"/>
         <element name="oleObjects" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_OleObjects" minOccurs="0"/>
         <element name="controls" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_Controls" minOccurs="0"/>
         <element name="webPublishItems" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_WebPublishItems" minOccurs="0"/>
         <element name="tableParts" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_TableParts" minOccurs="0"/>
         <element name="extLst" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}CT_ExtensionList" minOccurs="0"/>
       </sequence>
     </restriction>
   </complexContent>
 </complexType>

Field Summary

Fields
Modifier and Type	Field and Description
`protected CTAutoFilter`	`autoFilter`
`protected CTCellWatches`	`cellWatches`
`protected CTPageBreak`	`colBreaks`
`protected List<Cols>`	`cols`
`protected List<CTConditionalFormatting>`	`conditionalFormatting`
`protected CTControls`	`controls`
`protected CTCustomProperties`	`customProperties`
`protected CTCustomSheetViews`	`customSheetViews`
`protected CTDataConsolidate`	`dataConsolidate`
`protected CTDataValidations`	`dataValidations`
`protected CTSheetDimension`	`dimension`
`protected CTDrawing`	`drawing`
`protected CTDrawingHF`	`drawingHF`
`protected CTExtensionList`	`extLst`
`protected CTHeaderFooter`	`headerFooter`
`protected CTHyperlinks`	`hyperlinks`
`protected CTIgnoredErrors`	`ignoredErrors`
`protected CTLegacyDrawing`	`legacyDrawing`
`protected CTLegacyDrawing`	`legacyDrawingHF`
`protected CTMergeCells`	`mergeCells`
`protected CTOleObjects`	`oleObjects`
`protected CTPageMargins`	`pageMargins`
`protected CTPageSetup`	`pageSetup`
`protected CTPhoneticPr`	`phoneticPr`
`protected CTSheetBackgroundPicture`	`picture`
`protected CTPrintOptions`	`printOptions`
`protected CTProtectedRanges`	`protectedRanges`
`protected CTPageBreak`	`rowBreaks`
`protected CTScenarios`	`scenarios`
`protected CTSheetCalcPr`	`sheetCalcPr`
`protected SheetData`	`sheetData`
`protected CTSheetFormatPr`	`sheetFormatPr`
`protected CTSheetPr`	`sheetPr`
`protected CTSheetProtection`	`sheetProtection`
`protected SheetViews`	`sheetViews`
`protected CTSmartTags`	`smartTags`
`protected CTSortState`	`sortState`
`protected CTTableParts`	`tableParts`
`protected CTWebPublishItems`	`webPublishItems`

Constructor Summary

Constructors
Constructor and Description

Worksheet()

Constructors
Constructor and Description
`Worksheet()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`afterUnmarshal(Unmarshaller unmarshaller, Object parent)` This method is invoked by the JAXB implementation on each instance when unmarshalling completes.
`CTAutoFilter`	`getAutoFilter()` Gets the value of the autoFilter property.
`CTCellWatches`	`getCellWatches()` Gets the value of the cellWatches property.
`CTPageBreak`	`getColBreaks()` Gets the value of the colBreaks property.
`List<Cols>`	`getCols()` Gets the value of the cols property.
`List<CTConditionalFormatting>`	`getConditionalFormatting()` Gets the value of the conditionalFormatting property.
`CTControls`	`getControls()` Gets the value of the controls property.
`CTCustomProperties`	`getCustomProperties()` Gets the value of the customProperties property.
`CTCustomSheetViews`	`getCustomSheetViews()` Gets the value of the customSheetViews property.
`CTDataConsolidate`	`getDataConsolidate()` Gets the value of the dataConsolidate property.
`CTDataValidations`	`getDataValidations()` Gets the value of the dataValidations property.
`CTSheetDimension`	`getDimension()` Gets the value of the dimension property.
`CTDrawing`	`getDrawing()` Gets the value of the drawing property.
`CTDrawingHF`	`getDrawingHF()` Gets the value of the drawingHF property.
`CTExtensionList`	`getExtLst()` Gets the value of the extLst property.
`CTHeaderFooter`	`getHeaderFooter()` Gets the value of the headerFooter property.
`CTHyperlinks`	`getHyperlinks()` Gets the value of the hyperlinks property.
`CTIgnoredErrors`	`getIgnoredErrors()` Gets the value of the ignoredErrors property.
`CTLegacyDrawing`	`getLegacyDrawing()` Gets the value of the legacyDrawing property.
`CTLegacyDrawing`	`getLegacyDrawingHF()` Gets the value of the legacyDrawingHF property.
`CTMergeCells`	`getMergeCells()` Gets the value of the mergeCells property.
`CTOleObjects`	`getOleObjects()` Gets the value of the oleObjects property.
`CTPageMargins`	`getPageMargins()` Gets the value of the pageMargins property.
`CTPageSetup`	`getPageSetup()` Gets the value of the pageSetup property.
`Object`	`getParent()` Gets the parent object in the object tree representing the unmarshalled xml document.
`CTPhoneticPr`	`getPhoneticPr()` Gets the value of the phoneticPr property.
`CTSheetBackgroundPicture`	`getPicture()` Gets the value of the picture property.
`CTPrintOptions`	`getPrintOptions()` Gets the value of the printOptions property.
`CTProtectedRanges`	`getProtectedRanges()` Gets the value of the protectedRanges property.
`CTPageBreak`	`getRowBreaks()` Gets the value of the rowBreaks property.
`CTScenarios`	`getScenarios()` Gets the value of the scenarios property.
`CTSheetCalcPr`	`getSheetCalcPr()` Gets the value of the sheetCalcPr property.
`SheetData`	`getSheetData()` Gets the value of the sheetData property.
`CTSheetFormatPr`	`getSheetFormatPr()` Gets the value of the sheetFormatPr property.
`CTSheetPr`	`getSheetPr()` Gets the value of the sheetPr property.
`CTSheetProtection`	`getSheetProtection()` Gets the value of the sheetProtection property.
`SheetViews`	`getSheetViews()` Gets the value of the sheetViews property.
`CTSmartTags`	`getSmartTags()` Gets the value of the smartTags property.
`CTSortState`	`getSortState()` Gets the value of the sortState property.
`CTTableParts`	`getTableParts()` Gets the value of the tableParts property.
`CTWebPublishItems`	`getWebPublishItems()` Gets the value of the webPublishItems property.
`WorksheetPart`	`getWorksheetPart()` Get the WorksheetPart
`void`	`setAutoFilter(CTAutoFilter value)` Sets the value of the autoFilter property.
`void`	`setCellWatches(CTCellWatches value)` Sets the value of the cellWatches property.
`void`	`setColBreaks(CTPageBreak value)` Sets the value of the colBreaks property.
`void`	`setControls(CTControls value)` Sets the value of the controls property.
`void`	`setCustomProperties(CTCustomProperties value)` Sets the value of the customProperties property.
`void`	`setCustomSheetViews(CTCustomSheetViews value)` Sets the value of the customSheetViews property.
`void`	`setDataConsolidate(CTDataConsolidate value)` Sets the value of the dataConsolidate property.
`void`	`setDataValidations(CTDataValidations value)` Sets the value of the dataValidations property.
`void`	`setDimension(CTSheetDimension value)` Sets the value of the dimension property.
`void`	`setDrawing(CTDrawing value)` Sets the value of the drawing property.
`void`	`setDrawingHF(CTDrawingHF value)` Sets the value of the drawingHF property.
`void`	`setExtLst(CTExtensionList value)` Sets the value of the extLst property.
`void`	`setHeaderFooter(CTHeaderFooter value)` Sets the value of the headerFooter property.
`void`	`setHyperlinks(CTHyperlinks value)` Sets the value of the hyperlinks property.
`void`	`setIgnoredErrors(CTIgnoredErrors value)` Sets the value of the ignoredErrors property.
`void`	`setLegacyDrawing(CTLegacyDrawing value)` Sets the value of the legacyDrawing property.
`void`	`setLegacyDrawingHF(CTLegacyDrawing value)` Sets the value of the legacyDrawingHF property.
`void`	`setMergeCells(CTMergeCells value)` Sets the value of the mergeCells property.
`void`	`setOleObjects(CTOleObjects value)` Sets the value of the oleObjects property.
`void`	`setPageMargins(CTPageMargins value)` Sets the value of the pageMargins property.
`void`	`setPageSetup(CTPageSetup value)` Sets the value of the pageSetup property.
`void`	`setParent(Object parent)`
`void`	`setPhoneticPr(CTPhoneticPr value)` Sets the value of the phoneticPr property.
`void`	`setPicture(CTSheetBackgroundPicture value)` Sets the value of the picture property.
`void`	`setPrintOptions(CTPrintOptions value)` Sets the value of the printOptions property.
`void`	`setProtectedRanges(CTProtectedRanges value)` Sets the value of the protectedRanges property.
`void`	`setRowBreaks(CTPageBreak value)` Sets the value of the rowBreaks property.
`void`	`setScenarios(CTScenarios value)` Sets the value of the scenarios property.
`void`	`setSheetCalcPr(CTSheetCalcPr value)` Sets the value of the sheetCalcPr property.
`void`	`setSheetData(SheetData value)` Sets the value of the sheetData property.
`void`	`setSheetFormatPr(CTSheetFormatPr value)` Sets the value of the sheetFormatPr property.
`void`	`setSheetPr(CTSheetPr value)` Sets the value of the sheetPr property.
`void`	`setSheetProtection(CTSheetProtection value)` Sets the value of the sheetProtection property.
`void`	`setSheetViews(SheetViews value)` Sets the value of the sheetViews property.
`void`	`setSmartTags(CTSmartTags value)` Sets the value of the smartTags property.
`void`	`setSortState(CTSortState value)` Sets the value of the sortState property.
`void`	`setTableParts(CTTableParts value)` Sets the value of the tableParts property.
`void`	`setWebPublishItems(CTWebPublishItems value)` Sets the value of the webPublishItems property.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - sheetPr
```
protected CTSheetPr sheetPr
```
  - dimension
```
protected CTSheetDimension dimension
```
  - sheetViews
```
protected SheetViews sheetViews
```
  - sheetFormatPr
```
protected CTSheetFormatPr sheetFormatPr
```
  - cols
```
protected List<Cols> cols
```
  - sheetData
```
protected SheetData sheetData
```
  - sheetCalcPr
```
protected CTSheetCalcPr sheetCalcPr
```
  - sheetProtection
```
protected CTSheetProtection sheetProtection
```
  - protectedRanges
```
protected CTProtectedRanges protectedRanges
```
  - scenarios
```
protected CTScenarios scenarios
```
  - autoFilter
```
protected CTAutoFilter autoFilter
```
  - sortState
```
protected CTSortState sortState
```
  - dataConsolidate
```
protected CTDataConsolidate dataConsolidate
```
  - customSheetViews
```
protected CTCustomSheetViews customSheetViews
```
  - mergeCells
```
protected CTMergeCells mergeCells
```
  - phoneticPr
```
protected CTPhoneticPr phoneticPr
```
  - conditionalFormatting
```
protected List<CTConditionalFormatting> conditionalFormatting
```
  - dataValidations
```
protected CTDataValidations dataValidations
```
  - hyperlinks
```
protected CTHyperlinks hyperlinks
```
  - printOptions
```
protected CTPrintOptions printOptions
```
  - pageMargins
```
protected CTPageMargins pageMargins
```
  - pageSetup
```
protected CTPageSetup pageSetup
```
  - headerFooter
```
protected CTHeaderFooter headerFooter
```
  - rowBreaks
```
protected CTPageBreak rowBreaks
```
  - colBreaks
```
protected CTPageBreak colBreaks
```
  - customProperties
```
protected CTCustomProperties customProperties
```
  - cellWatches
```
protected CTCellWatches cellWatches
```
  - ignoredErrors
```
protected CTIgnoredErrors ignoredErrors
```
  - smartTags
```
protected CTSmartTags smartTags
```
  - drawing
```
protected CTDrawing drawing
```
  - legacyDrawing
```
protected CTLegacyDrawing legacyDrawing
```
  - legacyDrawingHF
```
protected CTLegacyDrawing legacyDrawingHF
```
  - drawingHF
```
protected CTDrawingHF drawingHF
```
  - picture
```
protected CTSheetBackgroundPicture picture
```
  - oleObjects
```
protected CTOleObjects oleObjects
```
  - controls
```
protected CTControls controls
```
  - webPublishItems
```
protected CTWebPublishItems webPublishItems
```
  - tableParts
```
protected CTTableParts tableParts
```
  - extLst
```
protected CTExtensionList extLst
```
- Constructor Detail
  - Worksheet
```
public Worksheet()
```
- Method Detail
  - getSheetPr
```
public CTSheetPr getSheetPr()
```
    Gets the value of the sheetPr property.
    
    Returns:
    
    possible object is CTSheetPr
  - setSheetPr
```
public void setSheetPr(CTSheetPr value)
```
    Sets the value of the sheetPr property.
    
    Parameters:
    
    value - allowed object is CTSheetPr
  - getDimension
```
public CTSheetDimension getDimension()
```
    Gets the value of the dimension property.
    
    Returns:
    
    possible object is CTSheetDimension
  - setDimension
```
public void setDimension(CTSheetDimension value)
```
    Sets the value of the dimension property.
    
    Parameters:
    
    value - allowed object is CTSheetDimension
  - getSheetViews
```
public SheetViews getSheetViews()
```
    Gets the value of the sheetViews property.
    
    Returns:
    
    possible object is SheetViews
  - setSheetViews
```
public void setSheetViews(SheetViews value)
```
    Sets the value of the sheetViews property.
    
    Parameters:
    
    value - allowed object is SheetViews
  - getSheetFormatPr
```
public CTSheetFormatPr getSheetFormatPr()
```
    Gets the value of the sheetFormatPr property.
    
    Returns:
    
    possible object is CTSheetFormatPr
  - setSheetFormatPr
```
public void setSheetFormatPr(CTSheetFormatPr value)
```
    Sets the value of the sheetFormatPr property.
    
    Parameters:
    
    value - allowed object is CTSheetFormatPr
  - getCols
```
public List<Cols> getCols()
```
    Gets the value of the cols property.
    This accessor method returns a reference to the live list, not a snapshot. Therefore any modification you make to the returned list will be present inside the JAXB object. This is why there is not a set method for the cols property.
    For example, to add a new item, do as follows:
```
    getCols().add(newItem);
 
```
    Objects of the following type(s) are allowed in the list Cols
  - getSheetData
```
public SheetData getSheetData()
```
    Gets the value of the sheetData property.
    
    Returns:
    
    possible object is SheetData
  - setSheetData
```
public void setSheetData(SheetData value)
```
    Sets the value of the sheetData property.
    
    Parameters:
    
    value - allowed object is SheetData
  - getSheetCalcPr
```
public CTSheetCalcPr getSheetCalcPr()
```
    Gets the value of the sheetCalcPr property.
    
    Returns:
    
    possible object is CTSheetCalcPr
  - setSheetCalcPr
```
public void setSheetCalcPr(CTSheetCalcPr value)
```
    Sets the value of the sheetCalcPr property.
    
    Parameters:
    
    value - allowed object is CTSheetCalcPr
  - getSheetProtection
```
public CTSheetProtection getSheetProtection()
```
    Gets the value of the sheetProtection property.
    
    Returns:
    
    possible object is CTSheetProtection
  - setSheetProtection
```
public void setSheetProtection(CTSheetProtection value)
```
    Sets the value of the sheetProtection property.
    
    Parameters:
    
    value - allowed object is CTSheetProtection
  - getProtectedRanges
```
public CTProtectedRanges getProtectedRanges()
```
    Gets the value of the protectedRanges property.
    
    Returns:
    
    possible object is CTProtectedRanges
  - setProtectedRanges
```
public void setProtectedRanges(CTProtectedRanges value)
```
    Sets the value of the protectedRanges property.
    
    Parameters:
    
    value - allowed object is CTProtectedRanges
  - getScenarios
```
public CTScenarios getScenarios()
```
    Gets the value of the scenarios property.
    
    Returns:
    
    possible object is CTScenarios
  - setScenarios
```
public void setScenarios(CTScenarios value)
```
    Sets the value of the scenarios property.
    
    Parameters:
    
    value - allowed object is CTScenarios
  - getAutoFilter
```
public CTAutoFilter getAutoFilter()
```
    Gets the value of the autoFilter property.
    
    Returns:
    
    possible object is CTAutoFilter
  - setAutoFilter
```
public void setAutoFilter(CTAutoFilter value)
```
    Sets the value of the autoFilter property.
    
    Parameters:
    
    value - allowed object is CTAutoFilter
  - getSortState
```
public CTSortState getSortState()
```
    Gets the value of the sortState property.
    
    Returns:
    
    possible object is CTSortState
  - setSortState
```
public void setSortState(CTSortState value)
```
    Sets the value of the sortState property.
    
    Parameters:
    
    value - allowed object is CTSortState
  - getDataConsolidate
```
public CTDataConsolidate getDataConsolidate()
```
    Gets the value of the dataConsolidate property.
    
    Returns:
    
    possible object is CTDataConsolidate
  - setDataConsolidate
```
public void setDataConsolidate(CTDataConsolidate value)
```
    Sets the value of the dataConsolidate property.
    
    Parameters:
    
    value - allowed object is CTDataConsolidate
  - getCustomSheetViews
```
public CTCustomSheetViews getCustomSheetViews()
```
    Gets the value of the customSheetViews property.
    
    Returns:
    
    possible object is CTCustomSheetViews
  - setCustomSheetViews
```
public void setCustomSheetViews(CTCustomSheetViews value)
```
    Sets the value of the customSheetViews property.
    
    Parameters:
    
    value - allowed object is CTCustomSheetViews
  - getMergeCells
```
public CTMergeCells getMergeCells()
```
    Gets the value of the mergeCells property.
    
    Returns:
    
    possible object is CTMergeCells
  - setMergeCells
```
public void setMergeCells(CTMergeCells value)
```
    Sets the value of the mergeCells property.
    
    Parameters:
    
    value - allowed object is CTMergeCells
  - getPhoneticPr
```
public CTPhoneticPr getPhoneticPr()
```
    Gets the value of the phoneticPr property.
    
    Returns:
    
    possible object is CTPhoneticPr
  - setPhoneticPr
```
public void setPhoneticPr(CTPhoneticPr value)
```
    Sets the value of the phoneticPr property.
    
    Parameters:
    
    value - allowed object is CTPhoneticPr
  - getConditionalFormatting
```
public List<CTConditionalFormatting> getConditionalFormatting()
```
    Gets the value of the conditionalFormatting property.
    This accessor method returns a reference to the live list, not a snapshot. Therefore any modification you make to the returned list will be present inside the JAXB object. This is why there is not a set method for the conditionalFormatting property.
    For example, to add a new item, do as follows:
```
    getConditionalFormatting().add(newItem);
 
```
    Objects of the following type(s) are allowed in the list CTConditionalFormatting
  - getDataValidations
```
public CTDataValidations getDataValidations()
```
    Gets the value of the dataValidations property.
    
    Returns:
    
    possible object is CTDataValidations
  - setDataValidations
```
public void setDataValidations(CTDataValidations value)
```
    Sets the value of the dataValidations property.
    
    Parameters:
    
    value - allowed object is CTDataValidations
  - getHyperlinks
```
public CTHyperlinks getHyperlinks()
```
    Gets the value of the hyperlinks property.
    
    Returns:
    
    possible object is CTHyperlinks
  - setHyperlinks
```
public void setHyperlinks(CTHyperlinks value)
```
    Sets the value of the hyperlinks property.
    
    Parameters:
    
    value - allowed object is CTHyperlinks
  - getPrintOptions
```
public CTPrintOptions getPrintOptions()
```
    Gets the value of the printOptions property.
    
    Returns:
    
    possible object is CTPrintOptions
  - setPrintOptions
```
public void setPrintOptions(CTPrintOptions value)
```
    Sets the value of the printOptions property.
    
    Parameters:
    
    value - allowed object is CTPrintOptions
  - getPageMargins
```
public CTPageMargins getPageMargins()
```
    Gets the value of the pageMargins property.
    
    Returns:
    
    possible object is CTPageMargins
  - setPageMargins
```
public void setPageMargins(CTPageMargins value)
```
    Sets the value of the pageMargins property.
    
    Parameters:
    
    value - allowed object is CTPageMargins
  - getPageSetup
```
public CTPageSetup getPageSetup()
```
    Gets the value of the pageSetup property.
    
    Returns:
    
    possible object is CTPageSetup
  - setPageSetup
```
public void setPageSetup(CTPageSetup value)
```
    Sets the value of the pageSetup property.
    
    Parameters:
    
    value - allowed object is CTPageSetup
  - getHeaderFooter
```
public CTHeaderFooter getHeaderFooter()
```
    Gets the value of the headerFooter property.
    
    Returns:
    
    possible object is CTHeaderFooter
  - setHeaderFooter
```
public void setHeaderFooter(CTHeaderFooter value)
```
    Sets the value of the headerFooter property.
    
    Parameters:
    
    value - allowed object is CTHeaderFooter
  - getRowBreaks
```
public CTPageBreak getRowBreaks()
```
    Gets the value of the rowBreaks property.
    
    Returns:
    
    possible object is CTPageBreak
  - setRowBreaks
```
public void setRowBreaks(CTPageBreak value)
```
    Sets the value of the rowBreaks property.
    
    Parameters:
    
    value - allowed object is CTPageBreak
  - getColBreaks
```
public CTPageBreak getColBreaks()
```
    Gets the value of the colBreaks property.
    
    Returns:
    
    possible object is CTPageBreak
  - setColBreaks
```
public void setColBreaks(CTPageBreak value)
```
    Sets the value of the colBreaks property.
    
    Parameters:
    
    value - allowed object is CTPageBreak
  - getCustomProperties
```
public CTCustomProperties getCustomProperties()
```
    Gets the value of the customProperties property.
    
    Returns:
    
    possible object is CTCustomProperties
  - setCustomProperties
```
public void setCustomProperties(CTCustomProperties value)
```
    Sets the value of the customProperties property.
    
    Parameters:
    
    value - allowed object is CTCustomProperties
  - getCellWatches
```
public CTCellWatches getCellWatches()
```
    Gets the value of the cellWatches property.
    
    Returns:
    
    possible object is CTCellWatches
  - setCellWatches
```
public void setCellWatches(CTCellWatches value)
```
    Sets the value of the cellWatches property.
    
    Parameters:
    
    value - allowed object is CTCellWatches
  - getIgnoredErrors
```
public CTIgnoredErrors getIgnoredErrors()
```
    Gets the value of the ignoredErrors property.
    
    Returns:
    
    possible object is CTIgnoredErrors
  - setIgnoredErrors
```
public void setIgnoredErrors(CTIgnoredErrors value)
```
    Sets the value of the ignoredErrors property.
    
    Parameters:
    
    value - allowed object is CTIgnoredErrors
  - getSmartTags
```
public CTSmartTags getSmartTags()
```
    Gets the value of the smartTags property.
    
    Returns:
    
    possible object is CTSmartTags
  - setSmartTags
```
public void setSmartTags(CTSmartTags value)
```
    Sets the value of the smartTags property.
    
    Parameters:
    
    value - allowed object is CTSmartTags
  - getDrawing
```
public CTDrawing getDrawing()
```
    Gets the value of the drawing property.
    
    Returns:
    
    possible object is CTDrawing
  - setDrawing
```
public void setDrawing(CTDrawing value)
```
    Sets the value of the drawing property.
    
    Parameters:
    
    value - allowed object is CTDrawing
  - getLegacyDrawing
```
public CTLegacyDrawing getLegacyDrawing()
```
    Gets the value of the legacyDrawing property.
    
    Returns:
    
    possible object is CTLegacyDrawing
  - setLegacyDrawing
```
public void setLegacyDrawing(CTLegacyDrawing value)
```
    Sets the value of the legacyDrawing property.
    
    Parameters:
    
    value - allowed object is CTLegacyDrawing
  - getLegacyDrawingHF
```
public CTLegacyDrawing getLegacyDrawingHF()
```
    Gets the value of the legacyDrawingHF property.
    
    Returns:
    
    possible object is CTLegacyDrawing
  - setLegacyDrawingHF
```
public void setLegacyDrawingHF(CTLegacyDrawing value)
```
    Sets the value of the legacyDrawingHF property.
    
    Parameters:
    
    value - allowed object is CTLegacyDrawing
  - getDrawingHF
```
public CTDrawingHF getDrawingHF()
```
    Gets the value of the drawingHF property.
    
    Returns:
    
    possible object is CTDrawingHF
  - setDrawingHF
```
public void setDrawingHF(CTDrawingHF value)
```
    Sets the value of the drawingHF property.
    
    Parameters:
    
    value - allowed object is CTDrawingHF
  - getPicture
```
public CTSheetBackgroundPicture getPicture()
```
    Gets the value of the picture property.
    
    Returns:
    
    possible object is CTSheetBackgroundPicture
  - setPicture
```
public void setPicture(CTSheetBackgroundPicture value)
```
    Sets the value of the picture property.
    
    Parameters:
    
    value - allowed object is CTSheetBackgroundPicture
  - getOleObjects
```
public CTOleObjects getOleObjects()
```
    Gets the value of the oleObjects property.
    
    Returns:
    
    possible object is CTOleObjects
  - setOleObjects
```
public void setOleObjects(CTOleObjects value)
```
    Sets the value of the oleObjects property.
    
    Parameters:
    
    value - allowed object is CTOleObjects
  - getControls
```
public CTControls getControls()
```
    Gets the value of the controls property.
    
    Returns:
    
    possible object is CTControls
  - setControls
```
public void setControls(CTControls value)
```
    Sets the value of the controls property.
    
    Parameters:
    
    value - allowed object is CTControls
  - getWebPublishItems
```
public CTWebPublishItems getWebPublishItems()
```
    Gets the value of the webPublishItems property.
    
    Returns:
    
    possible object is CTWebPublishItems
  - setWebPublishItems
```
public void setWebPublishItems(CTWebPublishItems value)
```
    Sets the value of the webPublishItems property.
    
    Parameters:
    
    value - allowed object is CTWebPublishItems
  - getTableParts
```
public CTTableParts getTableParts()
```
    Gets the value of the tableParts property.
    
    Returns:
    
    possible object is CTTableParts
  - setTableParts
```
public void setTableParts(CTTableParts value)
```
    Sets the value of the tableParts property.
    
    Parameters:
    
    value - allowed object is CTTableParts
  - getExtLst
```
public CTExtensionList getExtLst()
```
    Gets the value of the extLst property.
    
    Returns:
    
    possible object is CTExtensionList
  - setExtLst
```
public void setExtLst(CTExtensionList value)
```
    Sets the value of the extLst property.
    
    Parameters:
    
    value - allowed object is CTExtensionList
  - getWorksheetPart
```
public WorksheetPart getWorksheetPart()
```
    Get the WorksheetPart
    
    Returns:
    
    Since:
    
    3.3.3
  - getParent
```
public Object getParent()
```
    Gets the parent object in the object tree representing the unmarshalled xml document.
    
    Specified by:
    
    getParent in interface Child
    
    Returns:
    
    The parent object.
  - setParent
```
public void setParent(Object parent)
```
    Specified by:
    
    setParent in interface Child
  - afterUnmarshal
```
public void afterUnmarshal(Unmarshaller unmarshaller,
                           Object parent)
```
    This method is invoked by the JAXB implementation on each instance when unmarshalling completes.
    
    Parameters:
    
    parent - The parent object in the object tree.
    
    unmarshaller - The unmarshaller that generated the instance.

Class Worksheet

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

sheetPr

dimension

sheetViews

sheetFormatPr

cols

sheetData

sheetCalcPr

sheetProtection

protectedRanges

scenarios

autoFilter

sortState

dataConsolidate

customSheetViews

mergeCells

phoneticPr

conditionalFormatting

dataValidations

hyperlinks

printOptions

pageMargins

pageSetup

headerFooter

rowBreaks

colBreaks

customProperties

cellWatches

ignoredErrors

smartTags

drawing

legacyDrawing

legacyDrawingHF

drawingHF

picture

oleObjects

controls

webPublishItems

tableParts

extLst

Constructor Detail

Worksheet

Method Detail

getSheetPr

setSheetPr

getDimension

setDimension

getSheetViews

setSheetViews

getSheetFormatPr

setSheetFormatPr

getCols

getSheetData

setSheetData

getSheetCalcPr

setSheetCalcPr

getSheetProtection

setSheetProtection

getProtectedRanges

setProtectedRanges

getScenarios

setScenarios

getAutoFilter

setAutoFilter

getSortState

setSortState

getDataConsolidate

setDataConsolidate

getCustomSheetViews

setCustomSheetViews

getMergeCells

setMergeCells

getPhoneticPr

setPhoneticPr

getConditionalFormatting