Class ExcelPivotAreaReferenceItems

A list of pivot item refernces

Inheritance
object
EPPlusReadOnlyList<PivotItemReference>
ExcelPivotAreaReferenceItems
Implements
Inherited Members
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotAreaReferenceItems : EPPlusReadOnlyList<PivotItemReference>, IEnumerable<PivotItemReference>, IEnumerable

Methods

Add(int)

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
int 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
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
bool

true if the value has been added, otherwise false

Implements