Click or drag to resize

AutoFiltersCollection RemoveDateFilter Method

Removes a date filter.

Namespace: Spire.Xls.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void RemoveDateFilter(
	int columnIndex,
	DateTimeGroupingType dateTimeGroupingType,
	int year,
	int month,
	int day,
	int hour,
	int minute,
	int second
)

Parameters

columnIndex
Type: System Int32
The column field on which you want to base the filter . for exapmle: sheet.AutoFilters[0]
dateTimeGroupingType
Type: Spire.Xls.Core.Spreadsheet.AutoFilter DateTimeGroupingType
DateTimeGroupingType
year
Type: System Int32
The year.
month
Type: System Int32
The month.
day
Type: System Int32
The day.
hour
Type: System Int32
The hour.
minute
Type: System Int32
The minute.
second
Type: System Int32
The second.
Remarks
If DateTimeGroupingType is Year, only the param year effects. If DateTiemGroupingType is Month, only the param year and month effect.
See Also