<pivotCacheRecords>
(PivotCache Records)
Represents the collection of records in the PivotCache. This part stores the underlying source data that the PivotTable aggregates.
example:
<pivotCacheRecords xmlns="…" xmlns:r="…" count="2"> <r> <x v="0"/> <s v="Pacific"/> <x v="0"/> <s v="Australia"/> <x v="0"/> <x v="0"/> <s v="3550"/> <x v="0"/> <x v="0"/> <s v="Road-150 Red, 62"/> <s v="This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control."/> <s v="No Discount"/> … <n v="89.456800000000001"/> </r> …
Parent Elements |
---|
Root element of SpreadsheetML Pivot Table Cache Records part |
Child Elements |
Subclause |
---|---|
|
|
|
Attributes |
Description |
---|---|
|
Specifies the number of records in the cache. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_PivotCacheRecords">
<sequence>
<element name="r" minOccurs="0" maxOccurs="unbounded" type="CT_Record"/>
<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt"/>
</complexType>