Class ExcelPivotTableDataField

A pivot table data field

Inheritance

System.Object

XmlHelper

ExcelPivotTableDataField

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable

Assembly: EPPlus.dll

Syntax

public class ExcelPivotTableDataField : XmlHelper

Properties

BaseField

Field index. Reference to the field collection

Declaration

public int BaseField { get; set; }

Property Value

Type	Description
System.Int32

BaseItem

The index to the base item when the ShowDataAs calculation is in use

Declaration

public int BaseItem { get; set; }

Property Value

Type	Description
System.Int32

Field

The field

Declaration

public ExcelPivotTableField Field { get; }

Property Value

Type	Description
ExcelPivotTableField

Format

The number format for the data field

Declaration

public string Format { get; set; }

Property Value

Type	Description
System.String

Function

Type of aggregate function

Declaration

public DataFieldFunctions Function { get; set; }

Property Value

Type	Description
DataFieldFunctions

Index

The index of the datafield

Declaration

public int Index { get; }

Property Value

Type	Description
System.Int32

Name

The name of the datafield

Declaration

public string Name { get; set; }

Property Value

Type	Description
System.String

ShowDataAs

Represents a pivot fields Show As properties.

Declaration

public ExcelPivotTableDataFieldShowDataAs ShowDataAs { get; }

Property Value

Type	Description
ExcelPivotTableDataFieldShowDataAs