ssml:worksheet

Worksheet

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-sheet.xsd

Type: ssml:CT_Worksheet

Properties: Global, Qualified

Content

Sequence [1..1]
1. ssml:sheetPr [0..1] Worksheet Properties
2. ssml:dimension [0..1] Worksheet Dimensions
3. ssml:sheetViews [0..1] Sheet Views
4. ssml:sheetFormatPr [0..1] Sheet Format Properties
5. ssml:cols [0..*] Column Information
6. ssml:sheetData [1..1] Sheet Data
7. ssml:sheetCalcPr [0..1] Sheet Calculation Properties
8. ssml:sheetProtection [0..1] Sheet Protection
9. ssml:protectedRanges [0..1] Protected Ranges
10. ssml:scenarios [0..1] Scenarios
11. ssml:autoFilter [0..1] AutoFilter
12. ssml:sortState [0..1] Sort State
13. ssml:dataConsolidate [0..1] Data Consolidate
14. ssml:customSheetViews [0..1] Custom Sheet Views
15. ssml:mergeCells [0..1] Merge Cells
16. ssml:phoneticPr [0..1] Phonetic Properties
17. ssml:conditionalFormatting [0..*] Conditional Formatting
18. ssml:dataValidations [0..1] Data Validations
19. ssml:hyperlinks [0..1] Hyperlinks
20. ssml:printOptions [0..1] Print Options
21. ssml:pageMargins [0..1] Page Margins
22. ssml:pageSetup [0..1] Page Setup Settings
23. ssml:headerFooter [0..1] Header Footer Settings
24. ssml:rowBreaks [0..1] Horizontal Page Breaks
25. ssml:colBreaks [0..1] Vertical Page Breaks
26. ssml:customProperties [0..1] Custom Properties
27. ssml:cellWatches [0..1] Cell Watch Items
28. ssml:ignoredErrors [0..1] Ignored Errors
29. ssml:smartTags [0..1] Smart Tags
30. ssml:drawing [0..1] Drawing
31. ssml:legacyDrawing [0..1] Legacy Drawing
32. ssml:legacyDrawingHF [0..1] Legacy Drawing Header Footer
33. ssml:picture [0..1] Background Image
34. ssml:oleObjects [0..1] OLE Objects
35. ssml:controls [0..1] Embedded Controls
36. ssml:webPublishItems [0..1] Web Publishing Items
37. ssml:tableParts [0..1] Table Parts
38. ssml:extLst [0..1] Future Feature Storage Area

Attributes

None

Sample instance

<ssml:worksheet>
   <ssml:sheetPr>
      <ssml:tabColor/>
      <ssml:outlinePr/>
      <ssml:pageSetUpPr/>
   </ssml:sheetPr>
   <ssml:dimension ref="string"/>
   <ssml:sheetViews>
      <ssml:sheetView workbookViewId="1">
         <ssml:pane/>
         <ssml:selection sqref="A1 A1"/>
         <ssml:pivotSelection>...
         </ssml:pivotSelection>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:sheetView>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:sheetViews>
   <ssml:sheetFormatPr defaultRowHeight="1.0"/>
   <ssml:cols>
      <ssml:col min="1" max="1"/>
   </ssml:cols>
   <ssml:sheetData>
      <ssml:row>
         <ssml:c>...
         </ssml:c>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:row>
   </ssml:sheetData>
   <ssml:sheetCalcPr/>
   <ssml:sheetProtection/>
   <ssml:protectedRanges>
      <ssml:protectedRange sqref="string string" name="string"/>
   </ssml:protectedRanges>
   <ssml:scenarios sqref="string string">
      <ssml:scenario name="string">
         <ssml:inputCells r="string" val="string"/>
      </ssml:scenario>
   </ssml:scenarios>
   <ssml:autoFilter>
      <ssml:filterColumn colId="1">
         <ssml:filters>...
         </ssml:filters>
      </ssml:filterColumn>
      <ssml:sortState ref="string">
         <ssml:sortCondition ref="string" iconSet="3Arrows"/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:sortState>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:autoFilter>
   <ssml:sortState ref="string">
      <ssml:sortCondition ref="string" iconSet="3Arrows"/>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:sortState>
   <ssml:dataConsolidate>
      <ssml:dataRefs>
         <ssml:dataRef ref="string"/>
      </ssml:dataRefs>
   </ssml:dataConsolidate>
   <ssml:customSheetViews>
      <ssml:customSheetView guid="token">
         <ssml:pane/>
         <ssml:selection sqref="A1 A1"/>
         <ssml:rowBreaks>...
         </ssml:rowBreaks>
         <ssml:colBreaks>...
         </ssml:colBreaks>
         <ssml:pageMargins left="1.0" right="1.0" top="1.0" bottom="1.0" header="1.0" footer="1.0"/>
         <ssml:printOptions/>
         <ssml:pageSetup/>
         <ssml:headerFooter>...
         </ssml:headerFooter>
         <ssml:autoFilter>...
         </ssml:autoFilter>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:customSheetView>
   </ssml:customSheetViews>
   <ssml:mergeCells>
      <ssml:mergeCell ref="string"/>
   </ssml:mergeCells>
   <ssml:phoneticPr fontId="1"/>
   <ssml:conditionalFormatting>
      <ssml:cfRule priority="1">
         <ssml:formula>string</ssml:formula>
         <ssml:colorScale>...
         </ssml:colorScale>
         <ssml:dataBar>...
         </ssml:dataBar>
         <ssml:iconSet iconSet="3TrafficLights1">...
         </ssml:iconSet>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfRule>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:conditionalFormatting>
   <ssml:dataValidations>
      <ssml:dataValidation sqref="string string">
         <ssml:formula1>string</ssml:formula1>
         <ssml:formula2>string</ssml:formula2>
      </ssml:dataValidation>
   </ssml:dataValidations>
   <ssml:hyperlinks>
      <ssml:hyperlink ref="string"/>
   </ssml:hyperlinks>
   <ssml:printOptions/>
   <ssml:pageMargins left="1.0" right="1.0" top="1.0" bottom="1.0" header="1.0" footer="1.0"/>
   <ssml:pageSetup/>
   <ssml:headerFooter>
      <ssml:oddHeader>string</ssml:oddHeader>
      <ssml:oddFooter>string</ssml:oddFooter>
      <ssml:evenHeader>string</ssml:evenHeader>
      <ssml:evenFooter>string</ssml:evenFooter>
      <ssml:firstHeader>string</ssml:firstHeader>
      <ssml:firstFooter>string</ssml:firstFooter>
   </ssml:headerFooter>
   <ssml:rowBreaks>
      <ssml:brk/>
   </ssml:rowBreaks>
   <ssml:colBreaks>
      <ssml:brk/>
   </ssml:colBreaks>
   <ssml:customProperties>
      <ssml:customPr name="string" r:id="string"/>
   </ssml:customProperties>
   <ssml:cellWatches>
      <ssml:cellWatch r="string"/>
   </ssml:cellWatches>
   <ssml:ignoredErrors>
      <ssml:ignoredError sqref="string string"/>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:ignoredErrors>
   <ssml:smartTags>
      <ssml:cellSmartTags r="string">
         <ssml:cellSmartTag type="1">...
         </ssml:cellSmartTag>
      </ssml:cellSmartTags>
   </ssml:smartTags>
   <ssml:drawing r:id="string"/>
   <ssml:legacyDrawing r:id="string"/>
   <ssml:legacyDrawingHF r:id="string"/>
   <ssml:picture r:id="string"/>
   <ssml:oleObjects>
      <ssml:oleObject shapeId="1"/>
   </ssml:oleObjects>
   <ssml:controls>
      <ssml:control shapeId="1" r:id="string"/>
   </ssml:controls>
   <ssml:webPublishItems>
      <ssml:webPublishItem id="1" divId="string" sourceType="sheet" destinationFile="string"/>
   </ssml:webPublishItems>
   <ssml:tableParts>
      <ssml:tablePart r:id="string"/>
   </ssml:tableParts>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:worksheet>