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
intIndex 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
objectThe 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