Table of Contents

Class ExcelPivotAreaReferenceItems

Namespace
OfficeOpenXml.Table.PivotTable
Assembly
EPPlus.dll

A list of pivot item refernces

public class ExcelPivotAreaReferenceItems : EPPlusReadOnlyList<PivotItemReference>, IEnumerable<PivotItemReference>, IEnumerable
Inheritance
ExcelPivotAreaReferenceItems
Implements
Inherited Members

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