ssml:sheetView
Worksheet View
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Other elements with the same name: ssml:sheetView
Type: ssml:CT_SheetView
Properties: Local, Qualified
Content
- Sequence [1..1]
- ssml:pane [0..1] View Pane
- ssml:selection [0..4] Selection
- ssml:pivotSelection [0..4] PivotTable Selection
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| windowProtection | [0..1] | xsd:boolean | Window Protection | Default value is "false". |
| showFormulas | [0..1] | xsd:boolean | Show Formulas | Default value is "false". |
| showGridLines | [0..1] | xsd:boolean | Show Grid Lines | Default value is "true". |
| showRowColHeaders | [0..1] | xsd:boolean | Show Headers | Default value is "true". |
| showZeros | [0..1] | xsd:boolean | Show Zero Values | Default value is "true". |
| rightToLeft | [0..1] | xsd:boolean | Right To Left | Default value is "false". |
| tabSelected | [0..1] | xsd:boolean | Sheet Tab Selected | Default value is "false". |
| showRuler | [0..1] | xsd:boolean | Show Ruler | Default value is "true". |
| showOutlineSymbols | [0..1] | xsd:boolean | Show Outline Symbols | Default value is "true". |
| defaultGridColor | [0..1] | xsd:boolean | Default Grid Color | Default value is "true". |
| showWhiteSpace | [0..1] | xsd:boolean | Show White Space | Default value is "true". |
| view | [0..1] | ssml:ST_SheetViewType | View Type | Default value is "normal". |
| topLeftCell | [0..1] | ssml:ST_CellRef | Top Left Visible Cell | |
| colorId | [0..1] | xsd:unsignedInt | Color Id | Default value is "64". |
| zoomScale | [0..1] | xsd:unsignedInt | Zoom Scale | Default value is "100". |
| zoomScaleNormal | [0..1] | xsd:unsignedInt | Zoom Scale Normal View | Default value is "0". |
| zoomScaleSheetLayoutView | [0..1] | xsd:unsignedInt | Zoom Scale Page Break Preview | Default value is "0". |
| zoomScalePageLayoutView | [0..1] | xsd:unsignedInt | Zoom Scale Page Layout View | Default value is "0". |
| workbookViewId | [1..1] | xsd:unsignedInt | Workbook View Index |
Used in
- Type ssml:CT_SheetViews (Elements ssml:sheetViews, ssml:sheetViews, ssml:sheetViews)
Sample instance
<ssml:sheetView workbookViewId="1"> <ssml:pane/> <ssml:selection sqref="A1 A1"/> <ssml:pivotSelection> <ssml:pivotArea> <ssml:references>... </ssml:references> <ssml:extLst>... </ssml:extLst> </ssml:pivotArea> </ssml:pivotSelection> <ssml:extLst> <ssml:ext> <!--any element--> </ssml:ext> </ssml:extLst> </ssml:sheetView>