Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_Worksheet
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-sheet_xsd Drilldown into tableParts in schema sml-sheet_xsd Drilldown into webPublishItems in schema sml-sheet_xsd Drilldown into controls in schema sml-sheet_xsd Drilldown into oleObjects in schema sml-sheet_xsd Drilldown into picture in schema sml-sheet_xsd Drilldown into legacyDrawingHF in schema sml-sheet_xsd Drilldown into legacyDrawing in schema sml-sheet_xsd Drilldown into drawing in schema sml-sheet_xsd Drilldown into smartTags in schema sml-sheet_xsd Drilldown into ignoredErrors in schema sml-sheet_xsd Drilldown into cellWatches in schema sml-sheet_xsd Drilldown into customProperties in schema sml-sheet_xsd Drilldown into colBreaks in schema sml-sheet_xsd Drilldown into rowBreaks in schema sml-sheet_xsd Drilldown into headerFooter in schema sml-sheet_xsd Drilldown into pageSetup in schema sml-sheet_xsd Drilldown into pageMargins in schema sml-sheet_xsd Drilldown into printOptions in schema sml-sheet_xsd Drilldown into hyperlinks in schema sml-sheet_xsd Drilldown into dataValidations in schema sml-sheet_xsd Drilldown into conditionalFormatting in schema sml-sheet_xsd Drilldown into phoneticPr in schema sml-sheet_xsd Drilldown into mergeCells in schema sml-sheet_xsd Drilldown into customSheetViews in schema sml-sheet_xsd Drilldown into dataConsolidate in schema sml-sheet_xsd Drilldown into sortState in schema sml-sheet_xsd Drilldown into autoFilter in schema sml-sheet_xsd Drilldown into scenarios in schema sml-sheet_xsd Drilldown into protectedRanges in schema sml-sheet_xsd Drilldown into sheetProtection in schema sml-sheet_xsd Drilldown into sheetCalcPr in schema sml-sheet_xsd Drilldown into sheetData in schema sml-sheet_xsd Drilldown into cols in schema sml-sheet_xsd Drilldown into sheetFormatPr in schema sml-sheet_xsd Drilldown into sheetViews in schema sml-sheet_xsd Drilldown into dimension in schema sml-sheet_xsd Drilldown into sheetPr in schema sml-sheet_xsdXSD Diagram of CT_Worksheet in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_Worksheet">
    <xsd:sequence>
        <xsd:element name="sheetPr" type="CT_SheetPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Worksheet Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dimension" type="CT_SheetDimension" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Worksheet Dimensions</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetViews" type="CT_SheetViews" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Views</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetFormatPr" type="CT_SheetFormatPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Format Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="cols" type="CT_Cols" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Column Information</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetData" type="CT_SheetData" minOccurs="1" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Data</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetCalcPr" type="CT_SheetCalcPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Calculation Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sheet Protection</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="protectedRanges" type="CT_ProtectedRanges" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Protected Ranges</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="scenarios" type="CT_Scenarios" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Scenarios</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>AutoFilter</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Sort State</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dataConsolidate" type="CT_DataConsolidate" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Data Consolidate</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="customSheetViews" type="CT_CustomSheetViews" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Custom Sheet Views</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="mergeCells" type="CT_MergeCells" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Merge Cells</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="phoneticPr" type="CT_PhoneticPr" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Phonetic Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Conditional Formatting</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dataValidations" type="CT_DataValidations" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Data Validations</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="hyperlinks" type="CT_Hyperlinks" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Hyperlinks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Print Options</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Margins</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Setup Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Header and Footer Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Horizontal Page Breaks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Vertical Page Breaks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="customProperties" type="CT_CustomProperties" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Custom Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="cellWatches" type="CT_CellWatches" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Cell Watch Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ignoredErrors" type="CT_IgnoredErrors" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Ignored Errors</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="smartTags" type="CT_SmartTags" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Smart Tags</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="drawing" type="CT_Drawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Drawing</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Legacy Drawing</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Legacy Drawing Header Footer</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Background Image</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1">
        </xsd:element>
        <xsd:element name="controls" type="CT_Controls" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Embedded Controls</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="webPublishItems" type="CT_WebPublishItems" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Web Publishing Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="tableParts" type="CT_TableParts" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Table Parts</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
sheetPr nsM:sheetPr 0 1
dimension nsM:dimension 0 1
sheetViews nsM:sheetViews 0 1
sheetFormatPr nsM:sheetFormatPr 0 1
cols nsM:cols 0 unbounded
sheetData nsM:sheetData 1 1
sheetCalcPr nsM:sheetCalcPr 0 1
sheetProtection nsM:sheetProtection 0 1
protectedRanges nsM:protectedRanges 0 1
scenarios nsM:scenarios 0 1
autoFilter nsM:autoFilter 0 1
sortState nsM:sortState 0 1
dataConsolidate nsM:dataConsolidate 0 1
customSheetViews nsM:customSheetViews 0 1
mergeCells nsM:mergeCells 0 1
phoneticPr nsM:phoneticPr 0 1
conditionalFormatting nsM:conditionalFormatting 0 unbounded
dataValidations nsM:dataValidations 0 1
hyperlinks nsM:hyperlinks 0 1
printOptions nsM:printOptions 0 1
pageMargins nsM:pageMargins 0 1
pageSetup nsM:pageSetup 0 1
headerFooter nsM:headerFooter 0 1
rowBreaks nsM:rowBreaks 0 1
colBreaks nsM:colBreaks 0 1
customProperties nsM:customProperties 0 1
cellWatches nsM:cellWatches 0 1
ignoredErrors nsM:ignoredErrors 0 1
smartTags nsM:smartTags 0 1
drawing nsM:drawing 0 1
legacyDrawing nsM:legacyDrawing 0 1
legacyDrawingHF nsM:legacyDrawingHF 0 1
picture nsM:picture 0 1
oleObjects nsM:oleObjects 0 1
controls nsM:controls 0 1
webPublishItems nsM:webPublishItems 0 1
tableParts nsM:tableParts 0 1
extLst nsM:extLst 0 1
Collapse Derivation Tree:
Collapse References:
nsM:worksheet
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0