[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

autoFilter (AutoFilter Settings)

§3.3.1.1

cellWatches (Cell Watch Items)

§3.3.1.8

colBreaks (Vertical Page Breaks)

§3.3.1.13

cols (Column Information)

§3.3.1.16

conditionalFormatting (Conditional Formatting)

§3.3.1.17

controls (Embedded Controls)

§3.3.1.19

customProperties (Custom Properties)

§3.3.1.21

customSheetViews (Custom Sheet Views)

§3.3.1.25

dataConsolidate (Data Consolidate)

§3.3.1.27

dataValidations (Data Validations)

§3.3.1.31

dimension (Worksheet Dimensions)

§3.3.1.33

drawing (Drawing)

§3.3.1.34

extLst (Future Feature Data Storage Area)

§3.2.10

headerFooter (Header Footer Settings)

§3.3.1.43

hyperlinks (Hyperlinks)

§3.3.1.45

ignoredErrors (Ignored Errors)

§3.3.1.48

legacyDrawing (Legacy Drawing Reference)

§3.3.1.51

legacyDrawingHF (Legacy Drawing Reference in Header Footer)

§3.3.1.52

mergeCells (Merge Cells)

§3.3.1.54

oleObjects (Embedded Objects)

§3.3.1.58

pageMargins (Page Margins)

§3.3.1.60

pageSetup (Page Setup Settings)

§3.3.1.61

phoneticPr (Phonetic Properties)

§3.4.3

picture (Background Image)

§3.3.1.65

printOptions (Print Options)

§3.3.1.68

protectedRanges (Protected Ranges)

§3.3.1.70

rowBreaks (Horizontal Page Breaks (Row))

§3.3.1.72

scenarios (Scenarios)

§3.3.1.74

sheetCalcPr (Sheet Calculation Properties)

§3.3.1.76

sheetData (Sheet Data)

§3.3.1.77

sheetFormatPr (Sheet Format Properties)

§3.3.1.78

sheetPr (Sheet Properties)

§3.3.1.79

sheetProtection (Sheet Protection Options)

§3.3.1.81

sheetViews (Sheet Views)

§3.3.1.85

smartTags (Smart Tags)

§3.3.1.87

sortState (Sort State)

§3.3.1.89

tableParts (Table Parts)

§3.3.1.92

webPublishItems (Web Publishing Items)

§3.3.1.95

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>