Class ExcelFilterDateGroupItem

Namespace

OfficeOpenXml.Filter

Assembly

EPPlus.dll

A date group for filters

public class ExcelFilterDateGroupItem : ExcelFilterItem

Inheritance

object

ExcelFilterItem

ExcelFilterDateGroupItem

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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