Class ExcelPivotAreaReferenceCollection
A collection of pivot area references. A pivot area reference is a reference to a column, row field or a data field
Inheritance
System.Object
ExcelPivotAreaReferenceCollection
Implements
System.Collections.Generic.IEnumerable<ExcelPivotAreaReference>
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 ExcelPivotAreaReferenceCollection : EPPlusReadOnlyList<ExcelPivotAreaReference>, IEnumerable<ExcelPivotAreaReference>, IEnumerableMethods
Add(ExcelPivotTable, Int32)
Adds a pivot table field to the collection. The field is usually a column or row field
Declaration
public ExcelPivotAreaReference Add(ExcelPivotTable pivotTable, int fieldIndex)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelPivotTable | pivotTable | The pivot table |
| System.Int32 | fieldIndex | The index of the pivot table field |
Returns
| Type | Description |
|---|---|
| ExcelPivotAreaReference |
Add(ExcelPivotTableField)
Adds a pivot table field to the collection. The field is usually a column or row field
Declaration
public ExcelPivotAreaReference Add(ExcelPivotTableField field)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelPivotTableField | field | The column or row field |
Returns
| Type | Description |
|---|---|
| ExcelPivotAreaReference | The pivot area reference |
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable