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<ExcelPivotAreaReference>

IEnumerable

Inherited Members

EPPlusReadOnlyList<ExcelPivotAreaReference>.GetIndexByValue(ExcelPivotAreaReference)

EPPlusReadOnlyList<ExcelPivotAreaReference>.this[int]

EPPlusReadOnlyList<ExcelPivotAreaReference>.Count

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Methods

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

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