GrapeCity.Documents.Excel.ISlicerItem

ISlicerItem Interface

Represents an item in a slicer.

An ISlicerItem corresponds to a single value in a slicer cache and exposes its display value and selection state.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISlicerItem

Public Interface ISlicerItem

Examples

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

Properties

Name	Description
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.
Value	Gets the value of the slicer item. Use this property to retrieve the text value represented by an item in the SlicerItems collection.

Name

Description

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.

Value

Gets the value of the slicer item.

Use this property to retrieve the text value represented by an item in the SlicerItems collection.