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
)
 
Public Sub RemoveDateFilter ( 
	columnIndex As Integer,
	dateTimeGroupingType As DateTimeGroupingType,
	year As Integer,
	month As Integer,
	day As Integer,
	hour As Integer,
	minute As Integer,
	second As Integer
)
 
public:
void RemoveDateFilter(
	int columnIndex, 
	DateTimeGroupingType dateTimeGroupingType, 
	int year, 
	int month, 
	int day, 
	int hour, 
	int minute, 
	int second
)
 
member RemoveDateFilter : 
columnIndex : int * 
dateTimeGroupingType : DateTimeGroupingType * 
year : int * 
month : int * 
day : int * 
hour : int * 
minute : int * 
second : int -> unit 
 
 
 
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