GrapeCity.Documents.Excel.Workbook.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

public ISlicerCaches SlicerCaches { get; }

Public ReadOnly Property SlicerCaches As ISlicerCaches

Implements

IWorkbook.SlicerCaches

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");