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

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