Class ExcelPivotAreaReferenceCollection
A collection of pivot area references. A pivot area reference is a reference to a column, row field or a data field
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
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 |
| 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