Skip to main content

XlDateGroupItem.GroupingType Property

Gets which part of the DateTime value is used in the filter criteria.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public XlDateTimeGroupingType GroupingType { get; }

Property Value

Type Description
XlDateTimeGroupingType

An XlDateTimeGroupingType enumeration member.

Available values:

Name Description
Year

Groups the DateTime values by year.

Month

Groups the DateTime values by month.

Day

Groups the DateTime values by day.

Hour

Groups the DateTime values by hour.

Minute

Groups the DateTime values by minute.

Second

Groups the DateTime values by second.

Remarks

Each filter value for a date and time filter is defined by an instance of the XlDateGroupItem class. The XlDateGroupItem.Value property specifies the base date or time value to filter by. The GroupingType property specifies the part of the DateTime value to use in the filter criteria.

For example, an XlDateGroupItem instance with the GroupingType set to XlDateTimeGroupingType.Month and the XlDateGroupItem.Value set to DateTime(2017, 1, 6) filters all DateTime values that occur in January, 2017.

See Also