Skip to main content

CreateColorByName

Creates a color selecting it from one of the available color presets.

Syntax​

expression.CreateColorByName(sPresetColor);

expression - A variable that represents an Api class.

Parameters​

NameRequired/OptionalData typeDefaultDescription
sPresetColorRequiredPresetColorA preset selected from the list of the available color preset names.

Returns​

ApiColor

Example​

Pick a color from a built-in preset list to use on text or objects in a spreadsheet.

// How do I select a named color preset to apply to an element in a spreadsheet?

// Style text with a predefined color chosen by its name in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let color = Api.CreateColorByName("peachPuff");
worksheet.GetRange("A2").SetValue("Text with color");
worksheet.GetRange("A2").SetFontColor(color);