API Reference
Class
ExcelPivotDataField
Describes a data field in a pivot table (field name + aggregation).
Inheritance
- Object
- ExcelPivotDataField
Constructors
public ExcelPivotDataField(String fieldName, Nullable<DataConsolidateFunctionValues> function = null, String displayName = null, Nullable<UInt32> numberFormatId = null) #Creates a pivot data field definition.
Parameters
- fieldName System.String
- Header name from the source range.
- function System.Nullable{DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues} = null
- Aggregation function (Sum, Count, Average, ...).
- displayName System.String = null
- Optional display name for the data field.
- numberFormatId System.Nullable{System.UInt32} = null
- Optional number format id to apply to the data field.
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String FieldName { get; } #Gets the source field name.
public DataConsolidateFunctionValues Function { get; } #Gets the aggregation function.
public String DisplayName { get; } #Gets the optional display name for the data field.
public Nullable<UInt32> NumberFormatId { get; } #Gets the optional number format id for the data field.