Format::setFgColor -- Sets the cell's foreground color
Description
Sets the cell's foreground color. The color actually seen may depend on
the pattern being used (see setPattern()).
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
Example 29-1. Using setFgColor() 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(); |
|