PivotCacheRecords Class

Office 2010

PivotCache Records. It is 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

The following table lists the possible child types:

  • PivotCacheRecord <x:r>

  • ExtensionList <x:extLst>

[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
    <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.

Community Additions

© 2014 Microsoft