Class ExcelPivotAreaReferenceItems¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

A list of pivot item refernces

public class ExcelPivotAreaReferenceItems : EPPlusReadOnlyList<PivotItemReference>, IEnumerable<PivotItemReference>, IEnumerable

Inheritance¶

object ← EPPlusReadOnlyList<PivotItemReference> ← ExcelPivotAreaReferenceItems

Implements¶

IEnumerable
IEnumerable<PivotItemReference>

Inherited Members¶

EPPlusReadOnlyList<PivotItemReference>.Count
EPPlusReadOnlyList<PivotItemReference>.GetIndexByValue(PivotItemReference)
EPPlusReadOnlyList<PivotItemReference>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods¶

Add(int)¶

Adds the item at the index to the condition. The index referes to the pivot cache.

public void Add(int index)

Parameters¶

index int

Index into the pivot cache items. Either the shared items or the group items

AddByValue(object)¶

Adds a specific cache item to the condition. The value is matched against the values in the pivot cache, either the shared items or the group items.

public bool AddByValue(object value)

Parameters¶

value object

The value to match against. Is matched agaist the cache values and must be matched with the same data type.

Returns¶

bool

true if the value has been added, otherwise false