AutoFiltersCollection
AddDateFilter Method (IAutoFilter, DateTimeGroupingType, Int32, Int32, Int32, Int32, Int32, Int32)
|
Adds a date filter to the specified column based on the provided date grouping type and date components.
Namespace:
Spire.Xls.Collections
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void AddDateFilter(
IAutoFilter column,
DateTimeGroupingType dateTimeGroupingType,
int year,
int month,
int day,
int hour,
int minute,
int second
)
Public Sub AddDateFilter (
column As IAutoFilter,
dateTimeGroupingType As DateTimeGroupingType,
year As Integer,
month As Integer,
day As Integer,
hour As Integer,
minute As Integer,
second As Integer
)
public:
void AddDateFilter(
IAutoFilter^ column,
DateTimeGroupingType dateTimeGroupingType,
int year,
int month,
int day,
int hour,
int minute,
int second
)
member AddDateFilter :
column : IAutoFilter *
dateTimeGroupingType : DateTimeGroupingType *
year : int *
month : int *
day : int *
hour : int *
minute : int *
second : int -> unit
Parameters
-
column
-
Type:
Spire.Xls.Core
IAutoFilter
The column to which the date filter will be applied.
-
dateTimeGroupingType
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
DateTimeGroupingType
The type of date grouping to apply.
-
year
-
Type:
System
Int32
The year component of the date filter.
-
month
-
Type:
System
Int32
The month component of the date filter.
-
day
-
Type:
System
Int32
The day component of the date filter.
-
hour
-
Type:
System
Int32
The hour component of the date filter.
-
minute
-
Type:
System
Int32
The minute component of the date filter.
-
second
-
Type:
System
Int32
The second component of the date filter.
See Also