<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> (§3.3.1.29)

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 (§7.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 (§3.18.96).

<ref> (Reference)

Cell range.

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

<sheet> (Sheet Name)

Sheet name.

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

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_DataRef">
	<attribute name="ref" type="ST_Ref" use="optional"/>
	<attribute name="name" type="ST_Xstring" use="optional"/>
	<attribute name="sheet" type="ST_Xstring" use="optional"/>
	<attribute ref="r:id" use="optional"/>
</complexType>