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
)
Public Sub AddFillColorFilter (
columnIndex As Integer,
pattern As ExcelPatternType,
foreColor As Color,
backColor As Color
)
public:
void AddFillColorFilter(
int columnIndex,
ExcelPatternType pattern,
Color foreColor,
Color backColor
)
member AddFillColorFilter :
columnIndex : int *
pattern : ExcelPatternType *
foreColor : Color *
backColor : Color -> unit
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