GrapeCity.Documents.Excel.ISlicers.Count

Count Property

Count

Gets the number of ISlicer objects in the collection.

Use this property to determine how many slicers are associated with an ISlicerCache.

Declaration

int Count { get; }

ReadOnly Property Count As Integer

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetable", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ISlicerCache cache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
cache.Slicers.Add(worksheet, "categorySlicer", "Category", 20, 20, 120, 160);
int count = cache.Slicers.Count;