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