PivotCacheRecords class

Office 2013 and later

PivotCache Records. The root element of PivotTableCacheRecordsPart. When the object is serialized out as xml, its qualified name is x:pivotCacheRecords.

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

public class PivotCacheRecords : OpenXmlPartRootElement

[ISO/IEC 29500-1 1st Edition]

pivotCacheRecords (PivotCache Records)

Represents the collection of records in the PivotCache. This part stores the underlying source data that the PivotTable aggregates.


<pivotCacheRecords xmlns="…" xmlns:r="…" count="2">
    <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"/>

end example]

Parent Elements

Root element of SpreadsheetML Pivot Table Cache Records part

Child Elements


extLst (Future Feature Data Storage Area)


r (PivotCache Record)




count (PivotCache Records Count)

Specifies the number of records in the cache.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_PivotCacheRecords) is located in §A.2. end note]

© ISO/IEC29500: 2008.

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