DialogSheet Class
Dialog Sheet. It is the root element of DialogsheetPart.When the object is serialized out as xml, its qualified name is x:dialogsheet.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.OpenXmlPartRootElement
DocumentFormat.OpenXml.Spreadsheet.DialogSheet
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(DrawingHeaderFooter), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(PageMargins))> _
<ChildElementInfoAttribute(GetType(SheetProperties))> _
<ChildElementInfoAttribute(GetType(SheetViews))> _
<ChildElementInfoAttribute(GetType(SheetFormatProperties))> _
<ChildElementInfoAttribute(GetType(SheetProtection))> _
<ChildElementInfoAttribute(GetType(CustomSheetViews))> _
<ChildElementInfoAttribute(GetType(PrintOptions))> _
<ChildElementInfoAttribute(GetType(LegacyDrawing))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
<ChildElementInfoAttribute(GetType(HeaderFooter))> _
<ChildElementInfoAttribute(GetType(Drawing))> _
<ChildElementInfoAttribute(GetType(PageSetup))> _
<ChildElementInfoAttribute(GetType(LegacyDrawingHeaderFooter))> _
<ChildElementInfoAttribute(GetType(OleObjects))> _
<ChildElementInfoAttribute(GetType(Controls), FileFormatVersions.Office2010)> _
Public Class DialogSheet _
Inherits OpenXmlPartRootElement
'Usage
Dim instance As DialogSheet
[ChildElementInfoAttribute(typeof(DrawingHeaderFooter), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(PageMargins))]
[ChildElementInfoAttribute(typeof(SheetProperties))]
[ChildElementInfoAttribute(typeof(SheetViews))]
[ChildElementInfoAttribute(typeof(SheetFormatProperties))]
[ChildElementInfoAttribute(typeof(SheetProtection))]
[ChildElementInfoAttribute(typeof(CustomSheetViews))]
[ChildElementInfoAttribute(typeof(PrintOptions))]
[ChildElementInfoAttribute(typeof(LegacyDrawing))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
[ChildElementInfoAttribute(typeof(HeaderFooter))]
[ChildElementInfoAttribute(typeof(Drawing))]
[ChildElementInfoAttribute(typeof(PageSetup))]
[ChildElementInfoAttribute(typeof(LegacyDrawingHeaderFooter))]
[ChildElementInfoAttribute(typeof(OleObjects))]
[ChildElementInfoAttribute(typeof(Controls), FileFormatVersions.Office2010)]
public class DialogSheet : OpenXmlPartRootElement
Remarks
The following table lists the possible child types:
SheetProperties <x:sheetPr>
SheetViews <x:sheetViews>
SheetFormatProperties <x:sheetFormatPr>
SheetProtection <x:sheetProtection>
CustomSheetViews <x:customSheetViews>
PrintOptions <x:printOptions>
PageMargins <x:pageMargins>
PageSetup <x:pageSetup>
HeaderFooter <x:headerFooter>
Drawing <x:drawing>
LegacyDrawing <x:legacyDrawing>
LegacyDrawingHeaderFooter <x:legacyDrawingHF>
DrawingHeaderFooter <x:drawingHF>
OleObjects <x:oleObjects>
Controls <x:controls>
ExtensionList <x:extLst>
[ISO/IEC 29500-1 1st Edition]
18.3.1.34 dialogsheet (Dialog Sheet)
This is the root element for Dialogsheet parts within a SpreadsheetML document.
Parent Elements |
|---|
Root element of SpreadsheetML Dialogsheet part |
Child Elements |
Subclause |
|---|---|
customSheetViews (Custom Sheet Views) |
§18.3.1.27 |
drawing (Drawing) |
§18.3.1.36 |
drawingHF (Drawing Reference in Header Footer) |
§18.3.1.37 |
extLst (Future Feature Data Storage Area) |
§18.2.10 |
headerFooter (Header Footer Settings) |
§18.3.1.46 |
oleObjects (Embedded Objects) |
§18.3.1.60 |
pageMargins (Page Margins) |
§18.3.1.62 |
pageSetup (Page Setup Settings) |
§18.3.1.63 |
printOptions (Print Options) |
§18.3.1.70 |
sheetFormatPr (Sheet Format Properties) |
§18.3.1.81 |
sheetPr (Sheet Properties) |
§18.3.1.82 |
sheetProtection (Sheet Protection Options) |
§18.3.1.85 |
sheetViews (Sheet Views) |
§18.3.1.88 |
[Note: The W3C XML Schema definition of this element’s content model (CT_Dialogsheet) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.