Class ExcelSlicer<T>

Base class for table and pivot table slicers.

Inheritance
Object
XmlHelper
ExcelDrawing
ExcelSlicer<T>
ExcelPivotTableSlicer
ExcelTableSlicer
Implements
IDisposable
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Object.ToString()
Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll
Syntax
public abstract class ExcelSlicer<T> : ExcelDrawing, IDisposable where T : ExcelSlicerCache
Type Parameters
Name Description
T

The slicer cache data type

Properties

Cache

A reference to the slicer cache.

Declaration
public T Cache { get; }
Property Value
Type Description
T

Caption

The caption text of the slicer.

Declaration
public string Caption { get; set; }
Property Value
Type Description
String

ColumnCount

Number of columns. Default is 1.

Declaration
public int ColumnCount { get; set; }
Property Value
Type Description
Int32

DrawingType

The type of drawing

Declaration
public override eDrawingType DrawingType { get; }
Property Value
Type Description
eDrawingType
Overrides

LockedPosition

If the slicer view is locked or not.

Declaration
public bool LockedPosition { get; set; }
Property Value
Type Description
Boolean

RowHeight

Row height in points

Declaration
public double RowHeight { get; set; }
Property Value
Type Description
Double

ShowCaption

If the caption of the slicer is visible.

Declaration
public bool ShowCaption { get; set; }
Property Value
Type Description
Boolean

SlicerName

The the name of the slicer.

Declaration
public string SlicerName { get; set; }
Property Value
Type Description
String

StartItem

The index of the starting item in the slicer. Default is 0.

Declaration
public int StartItem { get; set; }
Property Value
Type Description
Int32

Style

The build in slicer style. If set to Custom, the name in the StyleName is used

Declaration
public eSlicerStyle Style { get; set; }
Property Value
Type Description
eSlicerStyle

StyleName

The style name used for the slicer. Style

Declaration
public string StyleName { get; set; }
Property Value
Type Description
String

Implements

System.IDisposable