Workbook::setCustomColor -- Change the RGB components of the elements in the colour palette.
Описание
Change the RGB components of the elements in the colour palette.
The new color, defined by the given RGB components, will "overwrite" the
color previously defined for the given index.
Параметр
integer $index -
colour index
integer $red -
red RGB value [0-255]
integer $green -
green RGB value [0-255]
integer $blue -
blue RGB value [0-255]
Возвращаемое значение
integer - The palette index for the custom color
Заметка
Эта функция не должна вызываться статически.
Пример
Пример 39-1. Using setCustomColor()
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(); |
|