Workbook::setCustomColor
Workbook::setCustomColor -- Change the RGB components of the elements in the colour palette.
Synopsis
require_once "Spreadsheet/Excel/Writer.php"; |
integer Workbook::setCustomColor (integer $index, integer $red, integer $green, integer $blue)
Description
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.
Parameter
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]
Return value
integer - The palette index for the custom color
Note
This function can not be called
statically.
Example
Example 43-1. Using setCustomColor()
<?php
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();
?>
|
|