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 Description
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 Description
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