Class ExcelPivotAreaDataFieldReference¶

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

A collection of data fields used in a pivot area selection

public class ExcelPivotAreaDataFieldReference : ExcelPivotAreaReferenceBase, IEnumerable<ExcelPivotTableDataField>, IEnumerable

Inheritance¶

object ← XmlHelper ← ExcelPivotAreaReferenceBase ← ExcelPivotAreaDataFieldReference

Implements¶

IEnumerable
IEnumerable<ExcelPivotTableDataField>

Inherited Members¶

ExcelPivotAreaReferenceBase.AvgSubtotal
ExcelPivotAreaReferenceBase.CountASubtotal
ExcelPivotAreaReferenceBase.CountSubtotal
ExcelPivotAreaReferenceBase.DefaultSubtotal
ExcelPivotAreaReferenceBase.MaxSubtotal
ExcelPivotAreaReferenceBase.MinSubtotal
ExcelPivotAreaReferenceBase.ProductSubtotal
ExcelPivotAreaReferenceBase.Selected
ExcelPivotAreaReferenceBase.StdDevPSubtotal
ExcelPivotAreaReferenceBase.StdDevSubtotal
ExcelPivotAreaReferenceBase.SumSubtotal
ExcelPivotAreaReferenceBase.VarPSubtotal
ExcelPivotAreaReferenceBase.VarSubtotal
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Count¶

Number of items in the collection

public int Count { get; }

Property Value¶

int

this[int]¶

The indexer

public ExcelPivotTableDataField this[int index] { get; }

Property Value¶

ExcelPivotTableDataField

Methods¶

Add(int)¶

Adds the data field at the specific index

public void Add(int index)

Parameters¶

index int

Add(ExcelPivotTableDataField)¶

Adds a data field from the pivot table to the pivot area

public void Add(ExcelPivotTableDataField field)

Parameters¶

field ExcelPivotTableDataField

GetEnumerator()¶

Gets the enumerator

public IEnumerator<ExcelPivotTableDataField> GetEnumerator()

Returns¶

IEnumerator<ExcelPivotTableDataField>