Interface ISlicerCache

Represents the slicer cache of the slicer.

Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public interface ISlicerCache

Properties

CrossFilterType

Gets or sets the cross filter type of the slicer

Declaration
SlicerCrossFilterType CrossFilterType { get; set; }
Property Value
Type
SlicerCrossFilterType
Examples

Following code illustrates how to get and change the CrossFilterType of the Slicer.

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];
   slicer.SlicerCache.CrossFilterType = SlicerCrossFilterType.HideItemsWithNoData;

   workbook.SaveAs("Slicer.xlsx");
   workbook.Close();
   excelEngine.Dispose();
}

IsAscending

Indicates whether the items in the slicer is sorted in the ascending order.

Declaration
bool IsAscending { get; set; }
Property Value
Type
System.Boolean
Examples

Following code illustrates how to get or set the sort order.

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];
   slicer.SlicerCache.IsAscending = true;

   workbook.SaveAs("Slicer.xlsx");
   workbook.Close();
   excelEngine.Dispose();
}

SlicerCacheItems

Gets the items of the slicer cache

Declaration
ISlicerCacheItems SlicerCacheItems { get; }
Property Value
Type
ISlicerCacheItems
Examples

Following code illustrates how to get or set the sort order.

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

SourceName

Gets the name of the cache field.

Declaration
string SourceName { get; }
Property Value
Type
System.String
Examples

Following code illustrates how to get the Name of the cache field.

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];
   string Name = slicer.SlicerCache.SourceName;

   workbook.SaveAs("Slicer.xlsx");
   workbook.Close();
   excelEngine.Dispose();
}

UseCustomListSorting

Indicates whether the custom list is used for sorting.

Declaration
bool UseCustomListSorting { get; set; }
Property Value
Type
System.Boolean
Examples

Following code illustrates how to set the Custom list sorting.

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];
   slicer.SlicerCache.UseCustomListSorting = true;

   workbook.SaveAs("Slicer.xlsx");
   workbook.Close();
   excelEngine.Dispose();
}

Extension Methods