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
Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotAreaReferenceCollection : EPPlusReadOnlyList<ExcelPivotAreaReference>, IEnumerable<ExcelPivotAreaReference>, IEnumerableMethods
Add(ExcelPivotTable, int)
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 |
| int | 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 |