require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet();
// 「通常の」緑色
$format_regular_green =& $workbook->addFormat();
$format_regular_green->setFgColor('green');
// 「特別な」緑色
$format_special_green =& $workbook->addFormat();
$format_special_green->setFgColor(11);
// 独自の緑色 (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, "通常の緑色", $format_regular_green);
$worksheet->write(1, 0, "特別な緑色 (色番号 11)", $format_special_green);
$worksheet->write(2, 0, "独自の緑色", $format_our_green);
$workbook->send('greens.xls');
$workbook->close(); |