GrapeCity.Documents.Excel.ISlicerItem.Selected

Selected Property

Selected

Gets or sets whether the slicer item is currently selected.

This property indicates whether the slicer item is included in the current slicer selection state.

Declaration

bool Selected { get; set; }

Property Selected As Boolean

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");
ISlicerItem slicerItem = slicerCache.SlicerItems["Fruit"];
bool selected = slicerItem.Selected;