Class SlicerCacheItem

SlicerCacheItem class

Represent slicer data source item

public class SlicerCacheItem

Properties

NameDescription
Selected { get; set; }Specifies whether the SlicerItem is selected or not.
Value { get; }Returns the label text for the slicer item. Read-only.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Slicers;

namespace AsposeCellsExamples
{
    public class SlicersClassSlicerCacheItemDemo
    {
        public static void Run()
        {
            // Load the workbook with slicer
            Workbook workbook = new Workbook("example.xlsx");
            workbook.Worksheets.RefreshAll();

            // Get the first slicer in the workbook
            var slicer = workbook.Worksheets
                .SelectMany(x => x.Slicers)
                .First();

            // Iterate through slicer cache items
            Console.WriteLine("Slicer Cache Items:");
            for (int i = 0; i < slicer.SlicerCache.SlicerCacheItems.Count; i++)
            {
                SlicerCacheItem slicerCacheItem = slicer.SlicerCache.SlicerCacheItems[i];
                Console.WriteLine($"Item {i}: Selected={slicerCacheItem.Selected}, Value={slicerCacheItem.Value}");
            }
        }
    }
}

See Also