Class ExcelPivotTableCacheField

A pivot tables cache field

Inheritance

System.Object

XmlHelper

ExcelPivotTableCacheField

Inherited Members

System.Object.Equals(System.Object)

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

System.Object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable

Assembly: EPPlus.dll

Syntax

public class ExcelPivotTableCacheField : XmlHelper

Properties

DateGrouping

The type of date grouping

Declaration

public eDateGroupBy DateGrouping { get; }

Property Value

Type	Description
eDateGroupBy

Format

The number format for the field

Declaration

public string Format { get; set; }

Property Value

Type	Description
System.String

Formula

The formula for cache field. The formula for the calculated field. Note: In formulas you create for calculated fields or calculated items, you can use operators and expressions as you do in other worksheet formulas. You can use constants and refer to data from the pivot table, but you cannot use cell references or defined names.You cannot use worksheet functions that require cell references or defined names as arguments, and you can not use array functions. AddCalculatedField(String, String)

Declaration

public string Formula { get; set; }

Property Value

Type	Description
System.String

Grouping

Grouping proprerties, if the field has grouping

Declaration

public ExcelPivotTableFieldGroup Grouping { get; set; }

Property Value

Type	Description
ExcelPivotTableFieldGroup

GroupItems

A list of group items, if the field has grouping. Grouping

Declaration

public EPPlusReadOnlyList<object> GroupItems { get; set; }

Property Value

Type	Description
EPPlusReadOnlyList<System.Object>

Index

The index in the collection of the pivot field

Declaration

public int Index { get; set; }

Property Value

Type	Description
System.Int32

Name

The name for the field

Declaration

public string Name { get; }

Property Value

Type	Description
System.String

SharedItems

A list of unique items for the field

Declaration

public EPPlusReadOnlyList<object> SharedItems { get; }

Property Value

Type	Description
EPPlusReadOnlyList<System.Object>