ExcelPivotTableField Members
From Office Open XML
| |
| EPPlus 3.0 |
| ExcelPivotTableField Members |
| ExcelPivotTableField Class Methods Properties See Also Send Feedback |
The ExcelPivotTableField type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
 | AddDateGrouping | Overloaded. |
| AddNumericGrouping |
Add numberic grouping to the field
|
| Equals | (Inherited from Object.) |
| GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) |
| GetType |
Gets the Type of the current instance.
(Inherited from Object.) |
| ToString | (Inherited from Object.) |
Properties
| Name | Description | |
|---|---|---|
 | Axis |
Type of axis
|
| Compact |
Compact mode
|
| Grouping |
Grouping settings.
Null if the field has no grouping otherwise ExcelPivotTableFieldNumericGroup or ExcelPivotTableFieldNumericGroup.
|
| IncludeNewItemsInFilter |
A boolean that indicates whether manual filter is in inclusive mode
|
| Index | |
| IsColumnField |
If the field is a column field
|
| IsDataField |
If the field is a datafield
|
| IsPageField |
If the field is a page field.
|
| IsRowField |
If the field is a row field
|
| Items |
Pivottable field Items. Used for grouping.
|
| Name |
Name of the field
|
| Outline |
A boolean that indicates whether the items in this field should be shown in Outline form
|
| PageFieldSettings | |
| ShowAll |
A boolean that indicates whether to show all items for this field
|
| Sort |
The type of sort that is applied to this field
|
| SubTotalFunctions |
Enumeration of the different subtotal operations that can be applied to page, row or column fields
|
| SubtotalTop |
The custom text that is displayed for the subtotals label
|
