<< xls_ExtendRange xls_link xls_GetData >>

xls_link >> xls_link > xls_GetColor

xls_GetColor

Get color of a range.

Calling Sequence

[backgroungColor [, fontColor]] = xls_GetColor([dataRange])

Parameters

dataRange

If dataRange is not specified, current range will be used.

fontColor

Font color in RGB [255, 0, 255].

Outputs

backgroungColor

Return the background color of dataRange.

fontColor

Return the font color of dataRange.

Description

Set color of a range.

Example

xls_NewExcel();
xls_AddWorkbook();
xls_SetVisible(%t);

xls_SetData("background");
xls_SetColor([255, 0, 0]);
xls_GetColor()
sleep(1000);
xls_SetData("background + font");
xls_SetColor([0, 255, 0], [255, 0, 0]);
[a,b] = xls_GetColor()
sleep(1000);

xls_SetSave(%t);
xls_Close();
xls_Quit();

See Also


Report an issue
<< xls_ExtendRange xls_link xls_GetData >>