GrapeCity.Documents.Excel.ISlicerCache.SlicerItems

SlicerItems Property

SlicerItems

Gets the ISlicerItems collection that contains all items in the slicer cache.

Use this property to access the cached items for the slicer's source field, including items that can be retrieved by index or by item name.

Declaration

ISlicerItems SlicerItems { get; }

ReadOnly Property SlicerItems As ISlicerItems

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Drink", 200},
    {"Fruit", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicerCache slicerCache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
ISlicerItems slicerItems = slicerCache.SlicerItems;
ISlicerItem slicerItem = slicerItems["Fruit"];