<worksheet> (Worksheet)
This is the root element of Sheet Parts that are of type 'worksheet'.
Parent Elements |
|---|
Root element of SpreadsheetML Worksheet part |
Child Elements |
Subclause |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_Worksheet">
<sequence>
<element name="sheetPr" type="CT_SheetPr" minOccurs="0" maxOccurs="1"/>
<element name="dimension" type="CT_SheetDimension" minOccurs="0" maxOccurs="1"/>
<element name="sheetViews" type="CT_SheetViews" minOccurs="0" maxOccurs="1"/>
<element name="sheetFormatPr" type="CT_SheetFormatPr" minOccurs="0" maxOccurs="1"/>
<element name="cols" type="CT_Cols" minOccurs="0" maxOccurs="unbounded"/>
<element name="sheetData" type="CT_SheetData" minOccurs="1" maxOccurs="1"/>
<element name="sheetCalcPr" type="CT_SheetCalcPr" minOccurs="0" maxOccurs="1"/>
<element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1"/>
<element name="protectedRanges" type="CT_ProtectedRanges" minOccurs="0" maxOccurs="1"/>
<element name="scenarios" type="CT_Scenarios" minOccurs="0" maxOccurs="1"/>
<element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1"/>
<element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1"/>
<element name="dataConsolidate" type="CT_DataConsolidate" minOccurs="0" maxOccurs="1"/>
<element name="customSheetViews" type="CT_CustomSheetViews" minOccurs="0" maxOccurs="1"/>
<element name="mergeCells" type="CT_MergeCells" minOccurs="0" maxOccurs="1"/>
<element name="phoneticPr" type="CT_PhoneticPr" minOccurs="0" maxOccurs="1"/>
<element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="0" maxOccurs="unbounded"/>
<element name="dataValidations" type="CT_DataValidations" minOccurs="0" maxOccurs="1"/>
<element name="hyperlinks" type="CT_Hyperlinks" minOccurs="0" maxOccurs="1"/>
<element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1"/>
<element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>
<element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1"/>
<element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>
<element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
<element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
<element name="customProperties" type="CT_CustomProperties" minOccurs="0" maxOccurs="1"/>
<element name="cellWatches" type="CT_CellWatches" minOccurs="0" maxOccurs="1"/>
<element name="ignoredErrors" type="CT_IgnoredErrors" minOccurs="0" maxOccurs="1"/>
<element name="smartTags" type="CT_SmartTags" minOccurs="0" maxOccurs="1"/>
<element name="drawing" type="CT_Drawing" minOccurs="0" maxOccurs="1"/>
<element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
<element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
<element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1"/>
<element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1"/>
<element name="controls" type="CT_Controls" minOccurs="0" maxOccurs="1"/>
<element name="webPublishItems" type="CT_WebPublishItems" minOccurs="0" maxOccurs="1"/>
<element name="tableParts" type="CT_TableParts" minOccurs="0" maxOccurs="1"/>
<element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
</sequence>
</complexType>