Class ExcelSlicer<T>

Base class for table and pivot table slicers.

Inheritance
System.Object
XmlHelper
ExcelDrawing
ExcelSlicer<T>
ExcelPivotTableSlicer
ExcelTableSlicer
Implements
System.IDisposable
Inherited Members
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 abstract class ExcelSlicer<T> : ExcelDrawing, IDisposable, IPictureContainer where T : ExcelSlicerCache
Type Parameters
Name Description
T

The slicer cache data type

Fields

_cache

Declaration
protected ExcelSlicerCache _cache
Field Value
Type Description
ExcelSlicerCache

_slicerXmlHelper

Declaration
protected XmlHelper _slicerXmlHelper
Field Value
Type Description
XmlHelper

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
System.String

ColumnCount

Number of columns. Default is 1.

Declaration
public int ColumnCount { get; set; }
Property Value
Type Description
System.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
System.Boolean

RowHeight

Row height in points

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

ShowCaption

If the caption of the slicer is visible.

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

SlicerName

The the name of the slicer.

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

StartItem

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

Declaration
public int StartItem { get; set; }
Property Value
Type Description
System.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
System.String

Implements

System.IDisposable