API Reference
ExcelPivotDataFieldInfo
Describes a data field in an existing pivot table.
Inheritance
- Object
- ExcelPivotDataFieldInfo
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Property ExcelPivotTableInfo.DataFields
Accepted by parameters
- Constructor ExcelPivotTableInfo.ExcelPivotTableInfo
- Constructor ExcelPivotTableInfo.ExcelPivotTableInfo
- Constructor ExcelPivotTableInfo.ExcelPivotTableInfo
Constructors
public ExcelPivotDataFieldInfo(String fieldName, DataConsolidateFunctionValues function, String displayName) #Creates a data field info instance.
Parameters
- fieldName System.String
- function DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues
- displayName System.String
public ExcelPivotDataFieldInfo(String fieldName, DataConsolidateFunctionValues function, String displayName, Nullable<UInt32> numberFormatId) #Creates a data field info instance.
Parameters
- fieldName System.String
- function DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues
- displayName System.String
- numberFormatId System.Nullable{System.UInt32}
public ExcelPivotDataFieldInfo(String fieldName, DataConsolidateFunctionValues function, String displayName, Nullable<UInt32> numberFormatId, String numberFormatCode) #Creates a data field info instance.
Parameters
- fieldName System.String
- function DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues
- displayName System.String
- numberFormatId System.Nullable{System.UInt32}
- numberFormatCode System.String
public ExcelPivotDataFieldInfo(String fieldName, DataConsolidateFunctionValues function, String displayName, Nullable<UInt32> numberFormatId, Nullable<ShowDataAsValues> showDataAs, Nullable<Int32> baseField, Nullable<UInt32> baseItem) #Creates a data field info instance.
Parameters
- fieldName System.String
- function DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues
- displayName System.String
- numberFormatId System.Nullable{System.UInt32}
- showDataAs System.Nullable{DocumentFormat.OpenXml.Spreadsheet.ShowDataAsValues}
- baseField System.Nullable{System.Int32}
- baseItem System.Nullable{System.UInt32}
public ExcelPivotDataFieldInfo(String fieldName, DataConsolidateFunctionValues function, String displayName, Nullable<UInt32> numberFormatId, String numberFormatCode, Nullable<ShowDataAsValues> showDataAs, Nullable<Int32> baseField, Nullable<UInt32> baseItem) #Creates a data field info instance.
Parameters
- fieldName System.String
- function DocumentFormat.OpenXml.Spreadsheet.DataConsolidateFunctionValues
- displayName System.String
- numberFormatId System.Nullable{System.UInt32}
- numberFormatCode System.String
- showDataAs System.Nullable{DocumentFormat.OpenXml.Spreadsheet.ShowDataAsValues}
- baseField System.Nullable{System.Int32}
- baseItem System.Nullable{System.UInt32}
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- 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 display name for the data field.
public Nullable<UInt32> NumberFormatId { get; } #Gets the number format id applied to the data field.
public String NumberFormatCode { get; } #Gets the custom number format code applied to the data field, when it can be resolved from workbook styles.
public Nullable<ShowDataAsValues> ShowDataAs { get; } #Gets the show-values-as calculation mode applied to the data field.
public Nullable<Int32> BaseField { get; } #Gets the base field index for show-values-as calculations that require one.
public Nullable<UInt32> BaseItem { get; } #Gets the base item index for show-values-as calculations that require one.