Format::setFgColor

Description

Sets the cell's foreground color. The color actually seen may depend on the pattern being used (see setPattern()).

Parameter

• mixed $color - either a string (like 'blue'), or an integer (range is [8...63]).

Using colors

The list of colors that can be defined by name is: 'black', 'white', 'red', 'green', 'blue', 'yellow', 'magenta' and 'cyan'. If you want to know how the other indexed colors look like, you can see it here. Beware that the color indexes are displaced by 1 with respect to those used by Spreadsheet_Excel_Writer.

If non of the predifined colors seems to be the color you are looking for, don't despair. You can use the setCustomColor() method to define a new color by its RGB components.

Note

This function can not be called statically.

Example

require_once 'Spreadsheet/Excel/Writer.php';

$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();

// "regular" green
$format_regular_green =& $workbook->addFormat();
$format_regular_green->setFgColor('green');

// "special" green
$format_special_green =& $workbook->addFormat();
$format_special_green->setFgColor(11);

// our green (overwriting color on index 12)
$workbook->setCustomColor(12, 10, 200, 10);
$format_our_green =& $workbook->addFormat();
$format_our_green->setFgColor(12);

$worksheet->setColumn(0, 0, 30);

$worksheet->write(0, 0, "Regular green", $format_regular_green);
$worksheet->write(1, 0, "Special green (index 11)", $format_special_green);
$worksheet->write(2, 0, "Our green", $format_our_green);

$workbook->send('greens.xls');
$workbook->close();