Class ExcelPivotTableDataField

Namespace

OfficeOpenXml.Table.PivotTable

Assembly

EPPlus.dll

A pivot table data field

public class ExcelPivotTableDataField : XmlHelper

Inheritance

object

XmlHelper

ExcelPivotTableDataField

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

BaseField

Field index. Reference to the field collection

public int BaseField { get; set; }

Property Value

int

BaseItem

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

public int BaseItem { get; set; }

Property Value

int

Field

The field

public ExcelPivotTableField Field { get; }

Property Value

ExcelPivotTableField

Format

The number format for the data field

public string Format { get; set; }

Property Value

string

Function

Type of aggregate function

public DataFieldFunctions Function { get; set; }

Property Value

DataFieldFunctions

Index

The index of the datafield

public int Index { get; }

Property Value

int

Name

The name of the datafield

public string Name { get; set; }

Property Value

string

ShowDataAs

Represents a pivot fields Show As properties.

public ExcelPivotTableDataFieldShowDataAs ShowDataAs { get; }

Property Value

ExcelPivotTableDataFieldShowDataAs