Class ExcelFilterDateGroupItem¶

Namespace: OfficeOpenXml.Filter
Assembly: EPPlus.dll

A date group for filters

public class ExcelFilterDateGroupItem : ExcelFilterItem

Inheritance¶

object ← ExcelFilterItem ← ExcelFilterDateGroupItem

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelFilterDateGroupItem(int)¶

Filter out the specified year

public ExcelFilterDateGroupItem(int year)

Parameters¶

year int

The year

ExcelFilterDateGroupItem(int, int)¶

Filter out the specified year and month

public ExcelFilterDateGroupItem(int year, int month)

Parameters¶

year int

The year

month int

The month

ExcelFilterDateGroupItem(int, int, int)¶

Filter out the specified year, month and day

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

Parameters¶

year int

The year

month int

The month

day int

The day

ExcelFilterDateGroupItem(int, int, int, int)¶

Filter out the specified year, month, day and hour

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

Parameters¶

year int

The year

month int

The month

day int

The day

hour int

The hour

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

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

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

Parameters¶

year int

The year

month int

The month

day int

The day

hour int

The hour

minute int

The minute

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

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

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

Parameters¶

year int

The year

month int

The month

day int

The day

hour int

The hour

minute int

The minute

second int

The second

Properties¶

Day¶

Day to filter on

public int? Day { get; }

Property Value¶

int?

Grouping¶

The grouping. Is set depending on the selected constructor

public eDateTimeGrouping Grouping { get; }

Property Value¶

eDateTimeGrouping

Hour¶

Hour to filter on

public int? Hour { get; }

Property Value¶

int?

Minute¶

Minute to filter on

public int? Minute { get; }

Property Value¶

int?

Month¶

Month to filter on

public int? Month { get; }

Property Value¶

int?

Second¶

Second to filter on

public int? Second { get; }

Property Value¶

int?

Year¶

Year to filter on

public int Year { get; }

Property Value¶

int