GrapeCity.Documents.Excel.ISlicerCache.Delete

Delete Method

Delete()

Deletes this slicer cache and all ISlicer objects associated with it.

After this method is called, the slicer cache is removed from the workbook's slicer cache collection.

Declaration

void Delete()

Sub Delete()

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Beverages", 100},
    {"Produce", 200},
    {"Snacks", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicerCache cache = workbook.SlicerCaches.Add(table, "Category");
cache.Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
cache.Delete();