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