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

IEnumerable

Inherited Members

ExcelPivotAreaReferenceBase.Selected

ExcelPivotAreaReferenceBase.DefaultSubtotal

ExcelPivotAreaReferenceBase.AvgSubtotal

ExcelPivotAreaReferenceBase.CountSubtotal

ExcelPivotAreaReferenceBase.CountASubtotal

ExcelPivotAreaReferenceBase.MaxSubtotal

ExcelPivotAreaReferenceBase.MinSubtotal

ExcelPivotAreaReferenceBase.ProductSubtotal

ExcelPivotAreaReferenceBase.StdDevPSubtotal

ExcelPivotAreaReferenceBase.StdDevSubtotal

ExcelPivotAreaReferenceBase.SumSubtotal

ExcelPivotAreaReferenceBase.VarPSubtotal

ExcelPivotAreaReferenceBase.VarSubtotal

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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; }

Parameters

index int

The zero-based index of the collection

Property Value

ExcelPivotTableDataField

Methods

Add(ExcelPivotTableDataField)

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

public void Add(ExcelPivotTableDataField field)

Parameters

field ExcelPivotTableDataField

Add(int)

Adds the data field at the specific index

public void Add(int index)

Parameters

index int

GetEnumerator()

Gets the enumerator

public IEnumerator<ExcelPivotTableDataField> GetEnumerator()

Returns

IEnumerator<ExcelPivotTableDataField>