PivotCaches Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

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

Condividi tramite