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.
Name | Type | Description |
oColor | ApiColor | The color object which specifies the color to be set to the background in the cell / cell range. |
builder.CreateFile("xlsx"); 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"); builder.SaveFile("xlsx", "SetFillColor.xlsx"); builder.CloseFile();