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¶

object ← XmlHelper ← ExcelDrawing ← ExcelSlicer<T>

Implements¶

IDisposable

Inherited Members¶

ExcelDrawing.AdjustPositionAndSize()
ExcelDrawing.As
ExcelDrawing.BringToFront()
ExcelDrawing.CellAnchor
ExcelDrawing.ChangeCellAnchor(eEditAs, int, int, int, int)
ExcelDrawing.ChangeCellAnchor(eEditAs)
ExcelDrawing.Description
ExcelDrawing.Dispose()
ExcelDrawing.DrawingType
ExcelDrawing.EditAs
ExcelDrawing.EMU_PER_CM
ExcelDrawing.EMU_PER_MM
ExcelDrawing.EMU_PER_PICA
ExcelDrawing.EMU_PER_PIXEL
ExcelDrawing.EMU_PER_POINT
ExcelDrawing.EMU_PER_US_INCH
ExcelDrawing.From
ExcelDrawing.Group(params ExcelDrawing[])
ExcelDrawing.Hyperlink
ExcelDrawing.Locked
ExcelDrawing.Name
ExcelDrawing.ParentGroup
ExcelDrawing.Position
ExcelDrawing.Print
ExcelDrawing.SendToBack()
ExcelDrawing.SetPosition(int, int, int, int)
ExcelDrawing.SetPosition(int, int)
ExcelDrawing.SetSize(int, int)
ExcelDrawing.SetSize(int)
ExcelDrawing.Size
ExcelDrawing.To
ExcelDrawing.UnGroup(bool)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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