SetFillColor
Sets the background color to the current cell range with the previously created color object. Sets 'No Fill' when previously created color object is null.
Syntax
expression.SetFillColor(oColor);
expression
- A variable that represents a ApiRange class.
Parameters
Name | Required/Optional | Data type | Default | Description |
---|---|---|---|---|
oColor | Required | ApiColor | The color object which specifies the color to be set to the background in the cell / cell range. |
Returns
This method doesn't return any data.
Example
This example sets the background color to the cell range with the previously created color object.
var oWorksheet = Api.GetActiveSheet();
oWorksheet.SetColumnWidth(0, 50);
oWorksheet.GetRange("A2").SetFillColor(Api.CreateColorFromRGB(255, 213, 191));
oWorksheet.GetRange("A2").SetValue("This is the cell with a color set to its background");
oWorksheet.GetRange("A4").SetValue("This is the cell with a default background color");