DataReference class

Office 2013 and later

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

Inheritance hierarchy

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

No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

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]

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