SheetViews Class

Sheet Views.When the object is serialized out as xml, its qualified name is x:sheetViews.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class SheetViews : OpenXmlCompositeElement

The following table lists the possible child types:

  • SheetView <x:sheetView>

  • ExtensionList <x:extLst>

[ISO/IEC 29500-1 1st Edition] sheetViews (Sheet Views)

Worksheet views collection.


This example shows one sheet view definition. The definition indicates that the current sheet is the active/selected sheet, and that there is a split pane applied to the view. This definition also indicates for each of the four window panes of the split which cell is the active cell for that pane.

<sheetView tabSelected="1" workbookViewId="0">
<pane xSplit="2310" ySplit="2070" topLeftCell="C1"
<selection pane="bottomLeft" activeCell="A6" sqref="A6"/>
<selection pane="topRight" activeCell="C1" sqref="C1"/>
<selection pane="bottomRight" activeCell="E13" sqref="E13"/>

end example]

Parent Elements

dialogsheet (§; worksheet (§

Child Elements


extLst (Future Feature Data Storage Area)


sheetView (Worksheet View)


[Note: The W3C XML Schema definition of this element’s content model (CT_SheetViews) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions