Class ExcelPivotAreaReferenceItems

A list of pivot item refernces

Inheritance
System.Object
EPPlusReadOnlyList<PivotItemReference>
ExcelPivotAreaReferenceItems
Implements
System.Collections.Generic.IEnumerable<PivotItemReference>
System.Collections.IEnumerable
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.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotAreaReferenceItems : EPPlusReadOnlyList<PivotItemReference>, IEnumerable<PivotItemReference>, IEnumerable

Methods

Add(Int32)

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

Declaration
public void Add(int index)
Parameters
Type Name Description
System.Int32 index

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.

Declaration
public bool AddByValue(object value)
Parameters
Type Name Description
System.Object value

The value to match against. Is matched agaist the cache values and must be matched with the same data type.
Returns
Type Description
System.Boolean

true if the value has been added, otherwise false

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable