PivotCaches class

Office 2013 and later

Defines the PivotCaches Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:pivotCaches.

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.4.12 pivotCaches

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A pivotCaches element is a CT_PivotCaches element, as specified in [ISO/IEC-29500-4] section A.2, that specifies a list of PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, PivotCache identifier elements. The list of elements specifies the PivotTable PivotCaches used by slicer caches, as specified in section 2.1.4, with OLAP slicer source data, as specified in section 2.3.2.1.1. See section 2.2.4.10 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="pivotCaches" type="x:CT_PivotCaches"/>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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