PivotCaches Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.PivotCaches

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(PivotCache))> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class PivotCaches _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotCaches
[ChildElementInfoAttribute(typeof(PivotCache))]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class PivotCaches : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • DocumentFormat.OpenXml.Spreadsheet.PivotCache <x:pivotCache>

2.4.10 pivotCaches

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

A CT_PivotCaches ([ISO/IEC-29500-4] section A.2) element that specifies a list of PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache identifier elements. The list of elements specifies the PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCaches used by slicer caches with OLAP slicer source data. See Workbook under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread Safety

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

See Also

Reference

PivotCaches Members

DocumentFormat.OpenXml.Office2010.Excel Namespace