[]
Represents the memory cache for a PivotTable report.
public interface IPivotCache| Name | Description |
|---|---|
| Index | Returns the index number of the object within the collection of similar objects. |
| RecordCount | Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. |
| RefreshDate | Returns the date on which the PivotTable cache was last refreshed. |
| RefreshName | Returns the name of the person who last refreshed the PivotTable cache. |
| RefreshOnFileOpen | Gets or sets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened. Defalut is false. |
| SourceData | Gets or sets the data source for the PivotTable report. |
| Name | Description |
|---|---|
| CreatePivotTable(IRange, string) | Creates a PivotTable report based on a PivotCache object. |
| Refresh() | Updates the cache of the PivotTable object. |