Show / Hide Table of Contents

Class ExcelTableSlicerCache

Represents a slicer cache with a table as source

Inheritance
System.Object
XmlHelper
ExcelSlicerCache
ExcelTableSlicerCache
Inherited Members
ExcelSlicerCache.CreatePart(ExcelWorkbook)
ExcelSlicerCache.SlicerCacheXml
ExcelSlicerCache.Name
ExcelSlicerCache.SourceName
ExcelSlicerCache.GetStartXml()
ExcelSlicerCache.CreateWorkbookReference(ExcelWorkbook, String)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll
Syntax
public class ExcelTableSlicerCache : ExcelSlicerCache

Properties

CrossFilter

How the items that are used in slicer cross filtering are displayed

Declaration
public eCrossFilter CrossFilter { get; set; }
Property Value
Type Description
eCrossFilter

CustomListSort

If custom lists are used when sorting the items

Declaration
public bool CustomListSort { get; set; }
Property Value
Type Description
System.Boolean

HideItemsWithNoData

If true, items that have no data are not displayed

Declaration
public bool HideItemsWithNoData { get; set; }
Property Value
Type Description
System.Boolean

SortOrder

How the table slicer items are sorted

Declaration
public eSortOrder SortOrder { get; set; }
Property Value
Type Description
eSortOrder

SourceType

The source type for the slicer cache

Declaration
public override eSlicerSourceType SourceType { get; }
Property Value
Type Description
eSlicerSourceType
Overrides
ExcelSlicerCache.SourceType

TableColumn

The table column that is the source for the slicer

Declaration
public ExcelTableColumn TableColumn { get; }
Property Value
Type Description
ExcelTableColumn
Back to top Generated by DocFX