Class ExcelPivotTableFieldDateGroup

A date group

Inheritance

object

XmlHelper

ExcelPivotTableFieldGroup

ExcelPivotTableFieldDateGroup

Inherited Members

ExcelPivotTableFieldGroup.BaseIndex

ExcelPivotTableFieldGroup.ParentIndex

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable

Assembly: EPPlus.dll

Syntax

public class ExcelPivotTableFieldDateGroup : ExcelPivotTableFieldGroup

Properties

AutoEnd

Auto detect end date

Declaration

public bool AutoEnd { get; }

Property Value

Type	Description
bool

AutoStart

Auto detect start date

Declaration

public bool AutoStart { get; }

Property Value

Type	Description
bool

EndDate

End date for the grouping

Declaration

public DateTime? EndDate { get; }

Property Value

Type	Description
DateTime?

GroupBy

How to group the date field

Declaration

public eDateGroupBy GroupBy { get; }

Property Value

Type	Description
eDateGroupBy

GroupInterval

Intervall if for day grouping

Declaration

public int? GroupInterval { get; }

Property Value

Type	Description
int?

StartDate

Start date for the grouping

Declaration

public DateTime? StartDate { get; }

Property Value

Type	Description
DateTime?