Class ExcelFilterDateGroupItem
A date group for filters
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 : ExcelFilterItemConstructors
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 |