Class ExcelPivotTableDataField

A pivo table data field

Inheritance

System.Object

XmlHelper

ExcelPivotTableDataField

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

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

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml.Table.PivotTable

Assembly: Experior.Core.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

Specifies 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

Number format for the data column

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