Class ExcelPivotTableCacheField¶

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

A pivot tables cache field

public class ExcelPivotTableCacheField : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelPivotTableCacheField

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

DateGrouping¶

The type of date grouping

public eDateGroupBy DateGrouping { get; }

Property Value¶

eDateGroupBy

Format¶

The number format for the field

public string Format { get; set; }

Property Value¶

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 cannot use array functions. AddCalculatedField(string, string)

public string Formula { get; set; }

Property Value¶

string

GroupItems¶

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

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

Property Value¶

EPPlusReadOnlyList<object>

Grouping¶

Grouping proprerties, if the field has grouping

public ExcelPivotTableFieldGroup Grouping { get; set; }

Property Value¶

ExcelPivotTableFieldGroup

Index¶

The index in the collection of the pivot field

public int Index { get; set; }

Property Value¶

int

Name¶

The name for the field

public string Name { get; }

Property Value¶

string

SharedItems¶

A list of unique items for the field

public EPPlusReadOnlyList<object> SharedItems { get; }

Property Value¶

EPPlusReadOnlyList<object>