Partager via


WorksheetDrawing Class

Worksheet Drawing. It is the root element of DrawingsPart.When the object is serialized out as xml, its qualified name is xdr:wsDr.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.OpenXmlPartRootElement
        DocumentFormat.OpenXml.Drawing.Spreadsheet.WorksheetDrawing

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(TwoCellAnchor))> _
<ChildElementInfoAttribute(GetType(AbsoluteAnchor))> _
<ChildElementInfoAttribute(GetType(OneCellAnchor))> _
Public Class WorksheetDrawing _
    Inherits OpenXmlPartRootElement
'Usage
Dim instance As WorksheetDrawing
[ChildElementInfoAttribute(typeof(TwoCellAnchor))]
[ChildElementInfoAttribute(typeof(AbsoluteAnchor))]
[ChildElementInfoAttribute(typeof(OneCellAnchor))]
public class WorksheetDrawing : OpenXmlPartRootElement

Remarks

The following table lists the possible child types:

  • TwoCellAnchor <xdr:twoCellAnchor>

  • OneCellAnchor <xdr:oneCellAnchor>

  • AbsoluteAnchor <xdr:absoluteAnchor>

[ISO/IEC 29500-1 1st Edition]

20.5.2.35 wsDr (Worksheet Drawing)

This element specifies all drawing objects within the worksheet. It acts much like the spTree element within the DrawingML framework. Allowing for the specification of all shapes for a given part of a document, in this case a single Worksheet.

Parent Elements

Root element of SpreadsheetML Drawing part

Child Elements

Subclause

absoluteAnchor (Absolute Anchor Shape Size)

§20.5.2.1

oneCellAnchor (One Cell Anchor Shape Size)

§20.5.2.24

twoCellAnchor (Two Cell Anchor Shape Size)

§20.5.2.33

[Note: The W3C XML Schema definition of this element’s content model (CT_Drawing) is located in §A.4.5. 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.

See Also

Reference

WorksheetDrawing Members

DocumentFormat.OpenXml.Drawing.Spreadsheet Namespace