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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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>