Table of Contents

Class ExcelSlicer<T>

Namespace
OfficeOpenXml.Drawing.Slicer
Assembly
EPPlus.dll

Base class for table and pivot table slicers.

public abstract class ExcelSlicer<T> : ExcelDrawing, IDisposable where T : ExcelSlicerCache

Type Parameters

T

The slicer cache data type

Inheritance
ExcelSlicer<T>
Implements
Derived
Inherited Members

Properties

Cache

A reference to the slicer cache.

public T Cache { get; }

Property Value

T

Caption

The caption text of the slicer.

public string Caption { get; set; }

Property Value

string

ColumnCount

Number of columns. Default is 1.

public int ColumnCount { get; set; }

Property Value

int

DrawingType

The type of drawing

public override eDrawingType DrawingType { get; }

Property Value

eDrawingType

LockedPosition

If the slicer view is locked or not.

public bool LockedPosition { get; set; }

Property Value

bool

RowHeight

Row height in points

public double RowHeight { get; set; }

Property Value

double

ShowCaption

If the caption of the slicer is visible.

public bool ShowCaption { get; set; }

Property Value

bool

SlicerName

The the name of the slicer.

public string SlicerName { get; set; }

Property Value

string

StartItem

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

public int StartItem { get; set; }

Property Value

int

Style

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

public eSlicerStyle Style { get; set; }

Property Value

eSlicerStyle

StyleName

The style name used for the slicer. Style

public string StyleName { get; set; }

Property Value

string