void Format::setFgColor (
Sets the cell's "foreground color".
The term "foreground color" is misleading. Here, "foreground" means the top layer of a cell's background. To set the color of a cell's contents, use the setColor() method.
The example entitled "How background and foreground colors interact with patterns" is very helpful.
either a string (like 'blue'), or an integer (range is [8...63]).
See the "Using colors" section, below, for more information.
The following colors can be defined by name:
To learn what the other indexed colors look like, read Color Palette and the 56 Excel ColorIndex Colors. Beware that the color indexes listed there are displaced by 1 with respect to those used by Spreadsheet_Excel_Writer.
If the predifined colors don't meet your requirements, use the setCustomColor() method.
This function can not be called statically.
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
// "regular" green
$format_regular_green =& $workbook->addFormat();
// "special" green
$format_special_green =& $workbook->addFormat();
// our green (overwriting color on index 12)
$workbook->setCustomColor(12, 10, 200, 10);
$format_our_green =& $workbook->addFormat();
$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);