PivotCaches Interface

Definition

Represents the collection of memory caches from the PivotTable reports in a workbook.

public interface class PivotCaches : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("0002441D-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotCaches : System.Collections.IEnumerable
Public Interface PivotCaches
Implements IEnumerable
Attributes
Implements

Remarks

Each memory cache is represented by a PivotCache object.

Use the PivotCaches() method to return the PivotCaches collection.

Properties

_Default[Object]

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application.

Count

Returns the number of objects in the collection.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Parent

Returns the parent object for the specified object.

Methods

Add(XlPivotTableSourceType, Object)

Adds a new PivotTable cache to a PivotCaches collection.

Create(XlPivotTableSourceType, Object, Object)

Creates a new PivotCache.

GetEnumerator()
Item(Object)

Returns a single object from a collection.

Applies to