Click or drag to resize

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
)

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