Class ExcelPivotTableDataField¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

A pivot table data field

public class ExcelPivotTableDataField : XmlHelper

Properties¶

Field index. Reference to the field collection

public int BaseField { get; set; }

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

public int BaseItem { get; set; }

The field

public ExcelPivotTableField Field { get; }

The number format for the data field

public string Format { get; set; }

Type of aggregate function

public DataFieldFunctions Function { get; set; }

The index of the datafield

public int Index { get; }

The name of the datafield

public string Name { get; set; }

Represents a pivot fields Show As properties.

public ExcelPivotTableDataFieldShowDataAs ShowDataAs { get; }