GrapeCity.Documents.Excel.ISlicerItem.Value

Value Property

Value

Gets the value of the slicer item.

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

Declaration

string Value { get; }

ReadOnly Property Value As String

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"];
string value = slicerItem.Value;