TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

SetFontColor

SetFontColor(oColor)

Sets the text color to the current cell range with the previously created color object.

Parameters:

Name Type Description
oColor ApiColor

The color object which specifies the color to be set to the text in the cell / cell range.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A2").SetFontColor(Api.CreateColorFromRGB(255, 111, 61));
oWorksheet.GetRange("A2").SetValue("This is the text with a color set to it");
oWorksheet.GetRange("A4").SetValue("This is the text with a default color");
builder.SaveFile("xlsx", "SetFontColor.xlsx");
builder.CloseFile();

Resulting document