Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
PivotCaches Interface
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.IEnumerablePublic 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
Feedback
Was this page helpful?