SetFill
Sets the fill properties to the current shape.
Syntax
expression.SetFill(oFill);
expression - A variable that represents a ApiShape class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| oFill | Required | ApiFill | The fill type used to fill the shape. |
Returns
boolean
Example
Apply a solid red fill to a rectangle shape after it is added to the sheet in a spreadsheet.
// How do I change the background color of a shape in a spreadsheet?
// Paint the interior of a shape with a chosen color to update its appearance in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let stroke = Api.CreateStroke(0, Api.CreateNoFill());
let shape = worksheet.AddShape("rect", 60 * 36000, 40 * 36000, Api.CreateNoFill(), stroke, 3, 0, 2, 2);
worksheet.GetRange("A1").SetValue("Original shape with no fill");
let fill = Api.CreateSolidFill(Api.CreateRGBColor(255, 0, 0));
shape.SetFill(fill);
worksheet.GetRange("A2").SetValue("Fill changed to red");