<worksheetSource> (Worksheet PivotCache Source)

Represents the location of the source of the data that is stored in the cache.

example: 
<cacheSource type="worksheet">
  <worksheetSource name="Table1" r:id="rId2"/>
</cacheSource>

Parent Elements

<cacheSource> (§3.10.1.7)

Attributes

Description

<id> (Relationship Id)

Namespace: .../officeDocument/2006/relationships

Specifies the identifier to the Sheet part whose data is stored in the cache. See the Sheet section (§3.2) for more information.

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

<name> (Named Range)

Specifies the named range that is the source of the data.

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

<ref> (Reference)

Specifies the reference that defines a cell range that is the source of the data. This attribute depends on how the application implements cell references.

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

<sheet> (Sheet Name)

Specifies the name of the sheet that is the source for the cached data.

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_WorksheetSource">
	<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>