Class ExcelPivotTableFieldCollection

A collection of pivot table fields

Inheritance
System.Object
ExcelPivotTableFieldCollectionBase<ExcelPivotTableField>
ExcelPivotTableFieldCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotTableField>
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 ExcelPivotTableFieldCollection : ExcelPivotTableFieldCollectionBase<ExcelPivotTableField>, IEnumerable<ExcelPivotTableField>, IEnumerable

Properties

Item[String]

Indexer by name

Declaration
public ExcelPivotTableField this[string name] { get; }
Parameters
Type Name Description
System.String name

The name
Property Value
Type Description
ExcelPivotTableField

The pivot table field

Methods

GetDateGroupField(eDateGroupBy)

Returns the date group field.

Declaration
public ExcelPivotTableField GetDateGroupField(eDateGroupBy GroupBy)
Parameters
Type Name Description
eDateGroupBy GroupBy

The type of grouping
Returns
Type Description
ExcelPivotTableField

The matching field. If none is found null is returned

GetNumericGroupField()

Returns the numeric group field.

Declaration
public ExcelPivotTableField GetNumericGroupField()
Returns
Type Description
ExcelPivotTableField

The matching field. If none is found null is returned

Implements

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