GrapeCity.Documents.Excel.ISlicerCache.List

List Property

List

Gets whether this slicer cache is based on a table.

This property returns true when the slicer cache was created from a table data source, and false when it was created from another supported data source such as a PivotTable.

Declaration

bool List { get; }

ReadOnly Property List As Boolean

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");
bool isTableSlicerCache = slicerCache.List;