JavaScript Editor Javascript validator     Web page editor 


Format::setFgColor -- Sets the cell's foreground color


require_once "Spreadsheet/Excel/Writer.php";

void Format::setFgColor (mixed $color)


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 color actually seen may depend on the pattern and background color being used.

The example entitled "How background and foreground colors interact with patterns" is very helpful.


Using colors

The following colors can be defined by name: black, white, red, green, blue, yellow, magenta and cyan.

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.



setBgColor(), setPattern(), setColor()

JavaScript Editor Javascript validator     Web page editor