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