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
IEnumerable<ExcelPivotTableSlicerItem>

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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; }

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()