ExcelPivotTableField Properties

Office Open XML

The ExcelPivotTableField type exposes the following members.

Properties

  NameDescription
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

See Also