Class ExcelFilterDateGroupItem
A date group for filters
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 : ExcelFilterItemConstructors
ExcelFilterDateGroupItem(Int32)
Filter out the specified year
Declaration
public ExcelFilterDateGroupItem(int year)Parameters
| Type | Name | Description |
|---|---|---|
| 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 |
|---|---|---|
| Int32 | year | The year |
| 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 |
|---|---|---|
| Int32 | year | The year |
| Int32 | month | The month |
| 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 |
|---|---|---|
| Int32 | year | The year |
| Int32 | month | The month |
| Int32 | day | The day |
| 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 |
|---|---|---|
| Int32 | year | The year |
| Int32 | month | The month |
| Int32 | day | The day |
| Int32 | hour | The hour |
| 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 |
|---|---|---|
| Int32 | year | The year |
| Int32 | month | The month |
| Int32 | day | The day |
| Int32 | hour | The hour |
| Int32 | minute | The minute |
| Int32 | second | The second |
Properties
Day
Day to filter on
Declaration
public int? Day { get; }Property Value
| Type | Description |
|---|---|
| Nullable<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 |
|---|---|
| Nullable<Int32> |
Minute
Minute to filter on
Declaration
public int? Minute { get; }Property Value
| Type | Description |
|---|---|
| Nullable<Int32> |
Month
Month to filter on
Declaration
public int? Month { get; }Property Value
| Type | Description |
|---|---|
| Nullable<Int32> |
Second
Second to filter on
Declaration
public int? Second { get; }Property Value
| Type | Description |
|---|---|
| Nullable<Int32> |
Year
Year to filter on
Declaration
public int Year { get; }Property Value
| Type | Description |
|---|---|
| Int32 |