Class ExcelPivotAreaReferenceCollection

A collection of pivot area references. A pivot area reference is a reference to a column, row field or a data field

Inheritance
System.Object
EPPlusReadOnlyList<ExcelPivotAreaReference>
ExcelPivotAreaReferenceCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotAreaReference>
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 ExcelPivotAreaReferenceCollection : EPPlusReadOnlyList<ExcelPivotAreaReference>, IEnumerable<ExcelPivotAreaReference>, IEnumerable

Methods

Add(ExcelPivotTable, Int32)

Adds a pivot table field to the collection. The field is usually a column or row field

Declaration
public ExcelPivotAreaReference Add(ExcelPivotTable pivotTable, int fieldIndex)
Parameters
Type Name Description
ExcelPivotTable pivotTable

The pivot table
System.Int32 fieldIndex

The index of the pivot table field
Returns
Type Description
ExcelPivotAreaReference

Add(ExcelPivotTableField)

Adds a pivot table field to the collection. The field is usually a column or row field

Declaration
public ExcelPivotAreaReference Add(ExcelPivotTableField field)
Parameters
Type Name Description
ExcelPivotTableField field

The column or row field
Returns
Type Description
ExcelPivotAreaReference

The pivot area reference

Implements

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