Partager via


SlicerCachePivotTables Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

The following table lists the possible child types:

  • SlicerCachePivotTable <x14:pivotTable>

2.6.66 CT_SlicerCachePivotTables

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

Referenced by: CT_SlicerCacheDefinition

A complex type that specifies a group of CT_SlicerCachePivotTable elements which specify the PivotTable ([ISO/IEC-29500-1] section 18.10) views that are filtered by the slicer cache.

Child Elements:

pivotTable : A CT_SlicerCachePivotTable element that specifies the PivotTable ([ISO/IEC-29500-1] section 18.10) view that is filtered. The list of pivotTable child elements MUST NOT contain duplicates. The showCalcMbrs attribute of all CT_PivotTableDefinition ([ISO/IEC-29500-4] section A.2) elements associated with PivotTables ([ISO/IEC-29500-1] section 18.10) that are specified by pivotTable child elements MUST have the same value.

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

<xsd:complexType name="CT_SlicerCachePivotTables">

<xsd:sequence>

<xsd:element name="pivotTable" type="CT_SlicerCachePivotTable" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

</xsd:complexType>

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

SlicerCachePivotTables Members

DocumentFormat.OpenXml.Office2010.Excel Namespace