[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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>
end example]
|
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>