Click or drag to resize

AutoFiltersCollection AddFillColorFilter Method (Int32, ExcelPatternType, Color, Color)

Adds a fill color filter.

Namespace: Spire.Xls.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void AddFillColorFilter(
	int columnIndex,
	ExcelPatternType pattern,
	Color foreColor,
	Color backColor
)

Parameters

columnIndex
Type: System Int32
The column field on which you want to base the filter. for exapmle: sheet.AutoFilters[0]
pattern
Type: Spire.Xls ExcelPatternType
The background pattern type.
foreColor
Type: System.Drawing Color
The foreground color.
backColor
Type: System.Drawing Color
The background color.
See Also