Class ExcelPivotAreaReferenceCollection¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

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

public class ExcelPivotAreaReferenceCollection : EPPlusReadOnlyList<ExcelPivotAreaReference>, IEnumerable<ExcelPivotAreaReference>, IEnumerable

Inheritance¶

object ← EPPlusReadOnlyList<ExcelPivotAreaReference> ← ExcelPivotAreaReferenceCollection

Implements¶

IEnumerable
IEnumerable<ExcelPivotAreaReference>

Inherited Members¶

EPPlusReadOnlyList<ExcelPivotAreaReference>.Count
EPPlusReadOnlyList<ExcelPivotAreaReference>.GetIndexByValue(ExcelPivotAreaReference)
EPPlusReadOnlyList<ExcelPivotAreaReference>.this[int]
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Methods¶

Add(ExcelPivotTableField)¶

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

public ExcelPivotAreaReference Add(ExcelPivotTableField field)

Parameters¶

field ExcelPivotTableField

The column or row field

Returns¶

ExcelPivotAreaReference

The pivot area reference

Add(ExcelPivotTable, int)¶

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

public ExcelPivotAreaReference Add(ExcelPivotTable pivotTable, int fieldIndex)

Parameters¶

pivotTable ExcelPivotTable

The pivot table

fieldIndex int

The index of the pivot table field

Returns¶

ExcelPivotAreaReference