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 : ExcelFilterItem
Constructors
ExcelFilterDateGroupItem(Int32)
Filter out the specified year
Declaration
public ExcelFilterDateGroupItem(int year)
Parameters
Type | Name | Description |
---|---|---|
System. |
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. |
year | The year |
System. |
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. |
year | The year |
System. |
month | The month |
System. |
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. |
year | The year |
System. |
month | The month |
System. |
day | The day |
System. |
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. |
year | The year |
System. |
month | The month |
System. |
day | The day |
System. |
hour | The hour |
System. |
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. |
year | The year |
System. |
month | The month |
System. |
day | The day |
System. |
hour | The hour |
System. |
minute | The minute |
System. |
second | The second |
Properties
Day
Day to filter on
Declaration
public int? Day { get; }
Property Value
Type | Description |
---|---|
System. |
Grouping
The grouping. Is set depending on the selected constructor
Declaration
public eDateTimeGrouping Grouping { get; }
Property Value
Type | Description |
---|---|
e |
Hour
Hour to filter on
Declaration
public int? Hour { get; }
Property Value
Type | Description |
---|---|
System. |
Minute
Minute to filter on
Declaration
public int? Minute { get; }
Property Value
Type | Description |
---|---|
System. |
Month
Month to filter on
Declaration
public int? Month { get; }
Property Value
Type | Description |
---|---|
System. |
Second
Second to filter on
Declaration
public int? Second { get; }
Property Value
Type | Description |
---|---|
System. |
Year
Year to filter on
Declaration
public int Year { get; }
Property Value
Type | Description |
---|---|
System. |