Class ExcelPivotAreaDataFieldReference

A collection of data fields used in a pivot area selection

Inheritance
System.Object
XmlHelper
ExcelPivotAreaReferenceBase
ExcelPivotAreaDataFieldReference
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableDataField>
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 ExcelPivotAreaDataFieldReference : ExcelPivotAreaReferenceBase, IEnumerable<ExcelPivotTableDataField>, IEnumerable

Properties

Count

Number of items in the collection

Declaration
public int Count { get; }
Property Value
Type Description
System.Int32

Item[Int32]

The indexer

Declaration
public ExcelPivotTableDataField this[int index] { get; }
Parameters
Type Name Description
System.Int32 index

The zero-based index of the collection
Property Value
Type Description
ExcelPivotTableDataField

Methods

Add(ExcelPivotTableDataField)

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

Declaration
public void Add(ExcelPivotTableDataField field)
Parameters
Type Name Description
ExcelPivotTableDataField field

Add(Int32)

Adds the data field at the specific index

Declaration
public void Add(int index)
Parameters
Type Name Description
System.Int32 index

GetEnumerator()

Gets the enumerator

Declaration
public IEnumerator<ExcelPivotTableDataField> GetEnumerator()
Returns
Type Description
System.Collections.Generic.IEnumerator<ExcelPivotTableDataField>

Explicit Interface Implementations

IEnumerable.GetEnumerator()

Gets the enumerator

Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
Type Description
System.Collections.IEnumerator

Implements

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