Class ExcelPivotTableSlicerItemCollection

Namespace

OfficeOpenXml.Drawing.Slicer

Assembly

EPPlus.dll

A collection of items in a pivot table slicer.

public class ExcelPivotTableSlicerItemCollection : IEnumerable<ExcelPivotTableSlicerItem>, IEnumerable

Inheritance

object

ExcelPivotTableSlicerItemCollection

Implements

IEnumerable<ExcelPivotTableSlicerItem>

IEnumerable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Count

Number of items in the collection.

public int Count { get; }

Property Value

int

this[int]

Get the value at the specific position in the collection

public ExcelPivotTableSlicerItem this[int index] { get; }

Parameters

index int

The position

Property Value

ExcelPivotTableSlicerItem

Methods

Contains(object)

It the object exists in the cache

public bool Contains(object value)

Parameters

value object

The object to check for existance

Returns

bool

GetByValue(object)

Get the item with supplied value.

public ExcelPivotTableSlicerItem GetByValue(object value)

Parameters

value object

The value

Returns

ExcelPivotTableSlicerItem

The item matching the supplied value. Returns null if no value matches.

GetEnumerator()

Get the enumerator for the collection

public IEnumerator<ExcelPivotTableSlicerItem> GetEnumerator()

Returns

IEnumerator<ExcelPivotTableSlicerItem>

GetIndexByValue(object)

Get the index of the item with supplied value.

public int GetIndexByValue(object value)

Parameters

value object

The value

Returns

int

The item matching the supplied value. Returns -1 if no value matches.

Refresh()

Refresh the items from the shared items or the group items.

public void Refresh()