Class ExcelPivotTableDataField

A pivot table data field

Inheritance

object

XmlHelper

ExcelPivotTableDataField

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
int

BaseItem

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

Declaration

public int BaseItem { get; set; }

Property Value

Type	Description
int

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
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
int

Name

The name of the datafield

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

ShowDataAs

Represents a pivot fields Show As properties.

Declaration

public ExcelPivotTableDataFieldShowDataAs ShowDataAs { get; }

Property Value

Type	Description
ExcelPivotTableDataFieldShowDataAs