GrapeCity.Documents.Excel.ISlicerCache.Slicers

Slicers Property

Slicers

Gets the ISlicers collection associated with this ISlicerCache.

The returned collection contains the ISlicer objects that use this slicer cache.

Declaration

ISlicers Slicers { get; }

ReadOnly Property Slicers As ISlicers

Examples

object[,] sourceData = {{"Category"}, {"Fruit"}, {"Vegetables"}};
worksheet.Range["A1:A3"].Value = sourceData;
ITable table = worksheet.Tables.Add(worksheet.Range["A1:A3"], true);
ISlicerCache slicerCache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
ISlicers slicers = slicerCache.Slicers;
slicers.Add(worksheet, "categorySlicer", "Category", 20, 20, 120, 160);