menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface ISlicerCacheItems - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface ISlicerCacheItems

    Respresents the slicer item collection of the slicer

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    public interface ISlicerCacheItems : IEnumerable

    Properties

    Count

    Gets or sets the the number of items present in the slicer.

    Declaration
    int Count { get; }
    Property Value
    Type
    System.Int32
    Examples

    Following code illustrates how to get the count of the slicer items.

    using (ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Slicer.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];     
    
       ISlicer slicer = worksheet.Slicers[0];
       int count = slicer.SlicerCache.SlicerCacheItems.Count;
    
       workbook.SaveAs("Slicer.xlsx");
       workbook.Close();
       excelEngine.Dispose();
    }        

    Item[Int32]

    Gets the slicer cache item object based on the given index.

    Declaration
    ISlicerCacheItem this[int index] { get; }
    Parameters
    Type Name Description
    System.Int32 index
    Property Value
    Type
    ISlicerCacheItem
    Examples

    Following code illustrates how to access the slicer cache items.

    using (ExcelEngine excelEngine = new ExcelEngine())
    {
      IApplication application = excelEngine.Excel;
      IWorkbook workbook = application.Workbooks.Open("Slicer.xlsx");
      IWorksheet worksheet = workbook.Worksheets[0];     
    
       ISlicer slicer = worksheet.Slicers[0];
       ISlicerCacheItems cacheItems = slicer.SlicerCache.SlicerCacheItems;
    
       workbook.SaveAs("Slicer.xlsx");
       workbook.Close();
       excelEngine.Dispose();
    }        

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved