Class ExcelFilterDateGroupItem

A date group for filters

Inheritance

System.Object

ExcelFilterItem

ExcelFilterDateGroupItem

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.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelFilterDateGroupItem : ExcelFilterItem

Constructors

ExcelFilterDateGroupItem(Int32)

Filter out the specified year

Declaration

public ExcelFilterDateGroupItem(int year)

Parameters

Type	Name	Description
System.Int32	year	The year

ExcelFilterDateGroupItem(Int32, Int32)

Filter out the specified year and month

Declaration

public ExcelFilterDateGroupItem(int year, int month)

Parameters

Type	Name	Description
System.Int32	year	The year
System.Int32	month	The month

ExcelFilterDateGroupItem(Int32, Int32, Int32)

Filter out the specified year, month and day

Declaration

public ExcelFilterDateGroupItem(int year, int month, int day)

Parameters

Type	Name	Description
System.Int32	year	The year
System.Int32	month	The month
System.Int32	day	The day

ExcelFilterDateGroupItem(Int32, Int32, Int32, Int32)

Filter out the specified year, month, day and hour

Declaration

public ExcelFilterDateGroupItem(int year, int month, int day, int hour)

Parameters

Type	Name	Description
System.Int32	year	The year
System.Int32	month	The month
System.Int32	day	The day
System.Int32	hour	The hour

ExcelFilterDateGroupItem(Int32, Int32, Int32, Int32, Int32)

Filter out the specified year, month, day, hour and and minute

Declaration

public ExcelFilterDateGroupItem(int year, int month, int day, int hour, int minute)

Parameters

Type	Name	Description
System.Int32	year	The year
System.Int32	month	The month
System.Int32	day	The day
System.Int32	hour	The hour
System.Int32	minute	The minute

ExcelFilterDateGroupItem(Int32, Int32, Int32, Int32, Int32, Int32)

Filter out the specified year, month, day, hour and and minute

Declaration

public ExcelFilterDateGroupItem(int year, int month, int day, int hour, int minute, int second)

Parameters

Type	Name	Description
System.Int32	year	The year
System.Int32	month	The month
System.Int32	day	The day
System.Int32	hour	The hour
System.Int32	minute	The minute
System.Int32	second	The second

Properties

Day

Day to filter on

Declaration

public int? Day { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Grouping

The grouping. Is set depending on the selected constructor

Declaration

public eDateTimeGrouping Grouping { get; }

Property Value

Type	Description
eDateTimeGrouping

Hour

Hour to filter on

Declaration

public int? Hour { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Minute

Minute to filter on

Declaration

public int? Minute { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Month

Month to filter on

Declaration

public int? Month { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Second

Second to filter on

Declaration

public int? Second { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Year

Year to filter on

Declaration

public int Year { get; }

Property Value

Type	Description
System.Int32