GrapeCity.Documents.Excel.IWorkbook.SlicerCaches

SlicerCaches Property

SlicerCaches

Returns the ISlicerCaches collection associated with the workbook.

Use this collection to access existing slicer caches in the workbook or to add new ones for supported data sources such as tables and PivotTables.

Declaration

ISlicerCaches SlicerCaches { get; }

ReadOnly Property SlicerCaches As ISlicerCaches

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetable", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ISlicerCaches slicerCaches = workbook.SlicerCaches;
ISlicerCache slicerCache = slicerCaches.Add(table, "Category");