GrapeCity.Documents.Excel.ISlicer.Delete

Delete Method

Delete()

Deletes the slicer and removes it from the associated ISlicers 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");
ISlicer slicer = cache.Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
slicer.Delete();