Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 700 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
Class

ExcelPivotDataFieldInfo

OfficeIMO.Excel

Edit on GitHub
Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
0eef6a5756b9 with working tree changes
Source
ExcelPivotDataFieldInfo.cs:12
Modifiers
sealed

Describes a data field in an existing pivot table.

Inheritance

  • object
  • ExcelPivotDataFieldInfo

Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 1

Accepted by parameters 1

Constructors

ExcelPivotDataFieldInfo 5 overloads
public ExcelPivotDataFieldInfo(string fieldName, ExcelPivotDataFunction function, string? displayName) #
ExcelPivotDataFieldInfo.cs:12

Creates a data field info instance.

Parameters

fieldName string required
function OfficeIMO.Excel.ExcelPivotDataFunction required
displayName string? required
public ExcelPivotDataFieldInfo(string fieldName, ExcelPivotDataFunction function, string? displayName, uint? numberFormatId) #
ExcelPivotDataFieldInfo.cs:18

Creates a data field info instance.

Parameters

fieldName string required
function OfficeIMO.Excel.ExcelPivotDataFunction required
displayName string? required
numberFormatId uint? required
public ExcelPivotDataFieldInfo(string fieldName, ExcelPivotDataFunction function, string? displayName, uint? numberFormatId, string? numberFormatCode) #
ExcelPivotDataFieldInfo.cs:28

Creates a data field info instance.

Parameters

fieldName string required
function OfficeIMO.Excel.ExcelPivotDataFunction required
displayName string? required
numberFormatId uint? required
numberFormatCode string? required
public ExcelPivotDataFieldInfo(string fieldName, ExcelPivotDataFunction function, string? displayName, uint? numberFormatId, ExcelPivotShowDataAs? showDataAs, int? baseField, uint? baseItem) #
ExcelPivotDataFieldInfo.cs:40

Creates a data field info instance.

Parameters

fieldName string required
function OfficeIMO.Excel.ExcelPivotDataFunction required
displayName string? required
numberFormatId uint? required
showDataAs OfficeIMO.Excel.ExcelPivotShowDataAs? required
baseField int? required
baseItem uint? required
public ExcelPivotDataFieldInfo(string fieldName, ExcelPivotDataFunction function, string? displayName, uint? numberFormatId, string? numberFormatCode, ExcelPivotShowDataAs? showDataAs, int? baseField, uint? baseItem) #
ExcelPivotDataFieldInfo.cs:54

Creates a data field info instance.

Parameters

fieldName string required
function OfficeIMO.Excel.ExcelPivotDataFunction required
displayName string? required
numberFormatId uint? required
numberFormatCode string? required
showDataAs OfficeIMO.Excel.ExcelPivotShowDataAs? required
baseField int? required
baseItem uint? required

Properties

public string FieldName { get; } #
ExcelPivotDataFieldInfo.cs:69

Gets the source field name.

public ExcelPivotDataFunction Function { get; } #
ExcelPivotDataFieldInfo.cs:74

Gets the aggregation function.

public string? DisplayName { get; } #
ExcelPivotDataFieldInfo.cs:79

Gets the display name for the data field.

public uint? NumberFormatId { get; } #
ExcelPivotDataFieldInfo.cs:84

Gets the number format id applied to the data field.

public string? NumberFormatCode { get; } #
ExcelPivotDataFieldInfo.cs:89

Gets the custom number format code applied to the data field, when it can be resolved from workbook styles.

public ExcelPivotShowDataAs? ShowDataAs { get; } #
ExcelPivotDataFieldInfo.cs:94

Gets the show-values-as calculation mode applied to the data field.

public int? BaseField { get; } #
ExcelPivotDataFieldInfo.cs:99

Gets the base field index for show-values-as calculations that require one.

public uint? BaseItem { get; } #
ExcelPivotDataFieldInfo.cs:104

Gets the base item index for show-values-as calculations that require one.