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)

[ChildElementInfoAttribute(typeof(ExtensionList))]
[ChildElementInfoAttribute(typeof(SheetView))]
public class SheetViews : OpenXmlCompositeElement

The following table lists the possible child types:

  • SheetView <x:sheetView>

  • ExtensionList <x:extLst>


[ISO/IEC 29500-1 1st Edition]

18.3.1.88 sheetViews (Sheet Views)

Worksheet views collection.

[Example:

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.

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

end example]

Parent Elements

dialogsheet (§18.3.1.34); worksheet (§18.3.1.99)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§18.2.10

sheetView (Worksheet View)

§18.3.1.87

[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

ADD
Show: