GrapeCity.Documents.Excel.ISlicer.SlicerCache

SlicerCache Property

SlicerCache

Gets the ISlicerCache object associated with the slicer.

The returned slicer cache contains the shared filtering data and settings that the slicer uses.

Declaration

ISlicerCache SlicerCache { get; }

ReadOnly Property SlicerCache As ISlicerCache

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetable", 200},
    {"Fruit", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicer slicer = workbook.SlicerCaches.Add(table, "Category")
    .Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
ISlicerCache slicerCache = slicer.SlicerCache;