Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
   
   package org.xlsx4j.schemas.microsoft.com.office.excel_2006.main;
   
   import java.util.ArrayList;
   import java.util.List;
  

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="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>
 
 
 @XmlType(name = "CT_Worksheet", propOrder = {
     "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",
     "picture",
     "oleObjects",
     "controls",
     "webPublishItems",
     "tableParts",
     "extLst"
 })
 public class CTWorksheet implements Child
 {
 
     protected CTSheetPr sheetPr;
     protected CTSheetDimension dimension;
     protected SheetViews sheetViews;
     protected CTSheetFormatPr sheetFormatPr;
     protected List<Colscols;
     @XmlElement(required = true)
     protected SheetData sheetData;
     protected CTSheetCalcPr sheetCalcPr;
     protected CTSheetProtection sheetProtection;
     protected CTProtectedRanges protectedRanges;
     protected CTScenarios scenarios;
     protected CTAutoFilter autoFilter;
     protected CTSortState sortState;
     protected CTDataConsolidate dataConsolidate;
     protected CTMergeCells mergeCells;
     protected CTPhoneticPr phoneticPr;
     protected CTDataValidations dataValidations;
     protected CTHyperlinks hyperlinks;
     protected CTPrintOptions printOptions;
     protected CTPageMargins pageMargins;
     protected CTPageSetup pageSetup;
     protected CTHeaderFooter headerFooter;
     protected CTPageBreak rowBreaks;
     protected CTPageBreak colBreaks;
     protected CTCellWatches cellWatches;
     protected CTIgnoredErrors ignoredErrors;
     protected CTSmartTags smartTags;
     protected CTDrawing drawing;
     protected CTSheetBackgroundPicture picture;
     protected CTOleObjects oleObjects;
     protected CTControls controls;
     protected CTWebPublishItems webPublishItems;
     protected CTTableParts tableParts;
     protected CTExtensionList extLst;
     @XmlTransient
     private Object parent;

    
Gets the value of the sheetPr property.

Returns:
possible object is
 
     public CTSheetPr getSheetPr() {
         return ;
     }

    
Sets the value of the sheetPr property.

Parameters:
value allowed object is
 
     public void setSheetPr(CTSheetPr value) {
         this. = value;
     }

    
Gets the value of the dimension property.

Returns:
possible object is
 
     public CTSheetDimension getDimension() {
         return ;
     }

    
Sets the value of the dimension property.

Parameters:
value allowed object is
 
     public void setDimension(CTSheetDimension value) {
         this. = value;
     }

    
Gets the value of the sheetViews property.

Returns:
possible object is
 
     public SheetViews getSheetViews() {
         return ;
     }

    
Sets the value of the sheetViews property.

Parameters:
value allowed object is
 
     public void setSheetViews(SheetViews value) {
         this. = value;
     }

    
Gets the value of the sheetFormatPr property.

Returns:
possible object is
 
     public CTSheetFormatPr getSheetFormatPr() {
         return ;
     }

    
Sets the value of the sheetFormatPr property.

Parameters:
value allowed object is
 
     public void setSheetFormatPr(CTSheetFormatPr value) {
         this. = value;
     }

    
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

 
     public List<ColsgetCols() {
         if ( == null) {
              = new ArrayList<Cols>();
         }
         return this.;
     }

    
Gets the value of the sheetData property.

Returns:
possible object is
 
     public SheetData getSheetData() {
         return ;
     }

    
Sets the value of the sheetData property.

Parameters:
value allowed object is
 
     public void setSheetData(SheetData value) {
         this. = value;
     }

    
Gets the value of the sheetCalcPr property.

Returns:
possible object is
 
     public CTSheetCalcPr getSheetCalcPr() {
         return ;
     }

    
Sets the value of the sheetCalcPr property.

Parameters:
value allowed object is
 
     public void setSheetCalcPr(CTSheetCalcPr value) {
         this. = value;
     }

    
Gets the value of the sheetProtection property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the sheetProtection property.

Parameters:
value allowed object is
 
     public void setSheetProtection(CTSheetProtection value) {
         this. = value;
     }

    
Gets the value of the protectedRanges property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the protectedRanges property.

Parameters:
value allowed object is
 
     public void setProtectedRanges(CTProtectedRanges value) {
         this. = value;
     }

    
Gets the value of the scenarios property.

Returns:
possible object is
 
     public CTScenarios getScenarios() {
         return ;
     }

    
Sets the value of the scenarios property.

Parameters:
value allowed object is
 
     public void setScenarios(CTScenarios value) {
         this. = value;
     }

    
Gets the value of the autoFilter property.

Returns:
possible object is
 
     public CTAutoFilter getAutoFilter() {
         return ;
     }

    
Sets the value of the autoFilter property.

Parameters:
value allowed object is
 
     public void setAutoFilter(CTAutoFilter value) {
         this. = value;
     }

    
Gets the value of the sortState property.

Returns:
possible object is
 
     public CTSortState getSortState() {
         return ;
     }

    
Sets the value of the sortState property.

Parameters:
value allowed object is
 
     public void setSortState(CTSortState value) {
         this. = value;
     }

    
Gets the value of the dataConsolidate property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the dataConsolidate property.

Parameters:
value allowed object is
 
     public void setDataConsolidate(CTDataConsolidate value) {
         this. = value;
     }

    
Gets the value of the customSheetViews property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the customSheetViews property.

Parameters:
value allowed object is
 
     public void setCustomSheetViews(CTCustomSheetViews value) {
         this. = value;
     }

    
Gets the value of the mergeCells property.

Returns:
possible object is
 
     public CTMergeCells getMergeCells() {
         return ;
     }

    
Sets the value of the mergeCells property.

Parameters:
value allowed object is
 
     public void setMergeCells(CTMergeCells value) {
         this. = value;
     }

    
Gets the value of the phoneticPr property.

Returns:
possible object is
 
     public CTPhoneticPr getPhoneticPr() {
         return ;
     }

    
Sets the value of the phoneticPr property.

Parameters:
value allowed object is
 
     public void setPhoneticPr(CTPhoneticPr value) {
         this. = value;
     }

    
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

 
         if ( == null) {
              = new ArrayList<CTConditionalFormatting>();
         }
         return this.;
     }

    
Gets the value of the dataValidations property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the dataValidations property.

Parameters:
value allowed object is
 
     public void setDataValidations(CTDataValidations value) {
         this. = value;
     }

    
Gets the value of the hyperlinks property.

Returns:
possible object is
 
     public CTHyperlinks getHyperlinks() {
         return ;
     }

    
Sets the value of the hyperlinks property.

Parameters:
value allowed object is
 
     public void setHyperlinks(CTHyperlinks value) {
         this. = value;
     }

    
Gets the value of the printOptions property.

Returns:
possible object is
 
     public CTPrintOptions getPrintOptions() {
         return ;
     }

    
Sets the value of the printOptions property.

Parameters:
value allowed object is
 
     public void setPrintOptions(CTPrintOptions value) {
         this. = value;
     }

    
Gets the value of the pageMargins property.

Returns:
possible object is
 
     public CTPageMargins getPageMargins() {
         return ;
     }

    
Sets the value of the pageMargins property.

Parameters:
value allowed object is
 
     public void setPageMargins(CTPageMargins value) {
         this. = value;
     }

    
Gets the value of the pageSetup property.

Returns:
possible object is
 
     public CTPageSetup getPageSetup() {
         return ;
     }

    
Sets the value of the pageSetup property.

Parameters:
value allowed object is
 
     public void setPageSetup(CTPageSetup value) {
         this. = value;
     }

    
Gets the value of the headerFooter property.

Returns:
possible object is
 
     public CTHeaderFooter getHeaderFooter() {
         return ;
     }

    
Sets the value of the headerFooter property.

Parameters:
value allowed object is
 
     public void setHeaderFooter(CTHeaderFooter value) {
         this. = value;
     }

    
Gets the value of the rowBreaks property.

Returns:
possible object is
 
     public CTPageBreak getRowBreaks() {
         return ;
     }

    
Sets the value of the rowBreaks property.

Parameters:
value allowed object is
 
     public void setRowBreaks(CTPageBreak value) {
         this. = value;
     }

    
Gets the value of the colBreaks property.

Returns:
possible object is
 
     public CTPageBreak getColBreaks() {
         return ;
     }

    
Sets the value of the colBreaks property.

Parameters:
value allowed object is
 
     public void setColBreaks(CTPageBreak value) {
         this. = value;
     }

    
Gets the value of the customProperties property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the customProperties property.

Parameters:
value allowed object is
 
     public void setCustomProperties(CTCustomProperties value) {
         this. = value;
     }

    
Gets the value of the cellWatches property.

Returns:
possible object is
 
     public CTCellWatches getCellWatches() {
         return ;
     }

    
Sets the value of the cellWatches property.

Parameters:
value allowed object is
 
     public void setCellWatches(CTCellWatches value) {
         this. = value;
     }

    
Gets the value of the ignoredErrors property.

Returns:
possible object is
 
     public CTIgnoredErrors getIgnoredErrors() {
         return ;
     }

    
Sets the value of the ignoredErrors property.

Parameters:
value allowed object is
 
     public void setIgnoredErrors(CTIgnoredErrors value) {
         this. = value;
     }

    
Gets the value of the smartTags property.

Returns:
possible object is
 
     public CTSmartTags getSmartTags() {
         return ;
     }

    
Sets the value of the smartTags property.

Parameters:
value allowed object is
 
     public void setSmartTags(CTSmartTags value) {
         this. = value;
     }

    
Gets the value of the drawing property.

Returns:
possible object is
 
     public CTDrawing getDrawing() {
         return ;
     }

    
Sets the value of the drawing property.

Parameters:
value allowed object is
 
     public void setDrawing(CTDrawing value) {
         this. = value;
     }

    
Gets the value of the picture property.

Returns:
possible object is
 
     public CTSheetBackgroundPicture getPicture() {
         return ;
     }

    
Sets the value of the picture property.

Parameters:
value allowed object is
 
     public void setPicture(CTSheetBackgroundPicture value) {
         this. = value;
     }

    
Gets the value of the oleObjects property.

Returns:
possible object is
 
     public CTOleObjects getOleObjects() {
         return ;
     }

    
Sets the value of the oleObjects property.

Parameters:
value allowed object is
 
     public void setOleObjects(CTOleObjects value) {
         this. = value;
     }

    
Gets the value of the controls property.

Returns:
possible object is
 
     public CTControls getControls() {
         return ;
     }

    
Sets the value of the controls property.

Parameters:
value allowed object is
 
     public void setControls(CTControls value) {
         this. = value;
     }

    
Gets the value of the webPublishItems property.

Returns:
possible object is
 
         return ;
     }

    
Sets the value of the webPublishItems property.

Parameters:
value allowed object is
    public void setWebPublishItems(CTWebPublishItems value) {
        this. = value;
    }

    
Gets the value of the tableParts property.

Returns:
possible object is
    public CTTableParts getTableParts() {
        return ;
    }

    
Sets the value of the tableParts property.

Parameters:
value allowed object is
    public void setTableParts(CTTableParts value) {
        this. = value;
    }

    
Gets the value of the extLst property.

Returns:
possible object is
    public CTExtensionList getExtLst() {
        return ;
    }

    
Sets the value of the extLst property.

Parameters:
value allowed object is
    public void setExtLst(CTExtensionList value) {
        this. = value;
    }

    
Gets the parent object in the object tree representing the unmarshalled xml document.

Returns:
The parent object.
    public Object getParent() {
        return this.;
    }
    public void setParent(Object parent) {
        this. = 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.
    public void afterUnmarshal(Unmarshaller unmarshallerObject parent) {
        setParent(parent);
    }
New to GrepCode? Check out our FAQ X