Class ExcelFilterDateGroupItem

A date group for filters

Inheritance

object

ExcelFilterItem

ExcelFilterDateGroupItem

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Filter

Assembly: EPPlus.dll

Syntax

public class ExcelFilterDateGroupItem : ExcelFilterItem

Constructors

ExcelFilterDateGroupItem(int)

Filter out the specified year

Declaration

public ExcelFilterDateGroupItem(int year)

Parameters

Type	Name	Description
int	year	The year

ExcelFilterDateGroupItem(int, int)

Filter out the specified year and month

Declaration

public ExcelFilterDateGroupItem(int year, int month)

Parameters

Type	Name	Description
int	year	The year
int	month	The month

ExcelFilterDateGroupItem(int, int, int)

Filter out the specified year, month and day

Declaration

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

Parameters

Type	Name	Description
int	year	The year
int	month	The month
int	day	The day

ExcelFilterDateGroupItem(int, int, int, int)

Filter out the specified year, month, day and hour

Declaration

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

Parameters

Type	Name	Description
int	year	The year
int	month	The month
int	day	The day
int	hour	The hour

ExcelFilterDateGroupItem(int, int, int, int, int)

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
int	year	The year
int	month	The month
int	day	The day
int	hour	The hour
int	minute	The minute

ExcelFilterDateGroupItem(int, int, int, int, int, int)

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
int	year	The year
int	month	The month
int	day	The day
int	hour	The hour
int	minute	The minute
int	second	The second

Properties

Day

Day to filter on

Declaration

public int? Day { get; }

Property Value

Type	Description
int?

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
int?

Minute

Minute to filter on

Declaration

public int? Minute { get; }

Property Value

Type	Description
int?

Month

Month to filter on

Declaration

public int? Month { get; }

Property Value

Type	Description
int?

Second

Second to filter on

Declaration

public int? Second { get; }

Property Value

Type	Description
int?

Year

Year to filter on

Declaration

public int Year { get; }

Property Value

Type	Description
int