Click or drag to resize

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
)

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