DataReference Class

Data Consolidation Reference.When the object is serialized out as xml, its qualified name is x:dataRef.

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

public class DataReference : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

18.3.1.30 dataRef (Data Consolidation Reference)

A single data consolidate reference. One dataRef shall use either name or sheet & ref, but not both on the same dataRef.

Parent Elements

dataRefs (§18.3.1.31)

Attributes

Description

id (relationship Id)

Namespace: .../officeDocument/2006/relationships

Used only when the source range is external to this workbook.

The possible values for this attribute are defined by the ST_RelationshipId simple type (§22.8.2.1).

name (Named Range)

Named range, either in this workbook or the external workbook referenced by r:Id.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

ref (Reference)

Cell range.

The possible values for this attribute are defined by the ST_Ref simple type (§18.18.62).

sheet (Sheet Name)

Sheet name.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

[Note: The W3C XML Schema definition of this element’s content model (CT_DataRef) 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: