GrapeCity.Documents.Excel.ISlicerCache.PivotTables

PivotTables Property

PivotTables

Gets the ISlicerPivotTables collection that contains the PivotTable objects currently filtered by the slicer cache.

Use this property to access the PivotTable objects associated with the current slicer cache.

Declaration

ISlicerPivotTables PivotTables { get; }

ReadOnly Property PivotTables As ISlicerPivotTables

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Beverages", 100},
    {"Produce", 200},
    {"Beverages", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
ISlicerCache slicerCache = workbook.SlicerCaches.Add(pivotTable, "Category");
ISlicerPivotTables pivotTables = slicerCache.PivotTables;