GrapeCity.Documents.Excel.IWorkbook.PivotCaches

PivotCaches Property

PivotCaches

Returns the IPivotCaches collection that contains all IPivotTable caches in the workbook.

Use this property to access existing PivotTable caches or create a new cache from source data before adding a PivotTable.

Declaration

IPivotCaches PivotCaches { get; }

ReadOnly Property PivotCaches As IPivotCaches

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Product", "Sales"},
    {"Apple", 100},
    {"Pear", 200},
    {"Orange", 150}
};
IPivotCaches pivotCaches = workbook.PivotCaches;
IPivotCache pivotCache = pivotCaches.Create(worksheet.Range["A1:B4"]);