Class ExcelSlicer<T>

Base class for table and pivot table slicers.

Inheritance
object
XmlHelper
ExcelDrawing
ExcelSlicer<T>
ExcelPivotTableSlicer
ExcelTableSlicer
Implements
Inherited Members
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
int

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
bool

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
bool

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
int

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