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();
}