AutoFiltersCollection
AddIconFilter Method
|
Adds an icon filter.
Namespace:
Spire.Xls.Collections
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void AddIconFilter(
int columnIndex,
IconSetType iconSetType,
int iconId
)
Public Sub AddIconFilter (
columnIndex As Integer,
iconSetType As IconSetType,
iconId As Integer
)
public:
void AddIconFilter(
int columnIndex,
IconSetType iconSetType,
int iconId
)
member AddIconFilter :
columnIndex : int *
iconSetType : IconSetType *
iconId : int -> unit
Parameters
-
columnIndex
-
Type:
System
Int32
The column field on which you want to base the filter. for exapmle: sheet.AutoFilters[0]
-
iconSetType
-
Type:
Spire.Xls
IconSetType
The icon set type.
-
iconId
-
Type:
System
Int32
The icon id.
Remarks
Only supports to add the icon filter.
Not supports checking which row is visible if the filter is icon filter.
See Also