文字や背景に各種装飾を行う

<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook->addWorksheet('シート(1)');

$row = 0;

$format =& $workbook->addFormat(array('Align' => 24));
$worksheet->writeString($row, 0, "フォントサイズ:24");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$format =& $workbook->addFormat(array('Size' => 24));
$worksheet->writeString($row, 0, "フォントサイズ:24");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$format =& $workbook->addFormat(array('Align' => 'center'));
$worksheet->writeString($row, 0, "表示位置:センター");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$format =& $workbook->addFormat(array('Color' => 'blue'));
$worksheet->writeString($row, 0, "文字色:青色");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$format =& $workbook->addFormat(array('Pattern' => 18));
$worksheet->writeString($row, 0, "パターン:18");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$format =& $workbook->addFormat(array('Pattern' => 18, 'FgColor' => 'red', 'BgColor' => 'yellow'));
$worksheet->writeString($row, 0, "パターン:18 前景色:赤色 背景色:黄色");
$worksheet->writeString($row, 1, "テスト", $format);
$row++;

$workbook->send('addFormat.xls');
$workbook->close();

【作成したExcelの内容】

こんな感じで生成し、

$format =& $workbook->addFormat(array('Align' => 24));

writeString メソッドの第4引数に設定し、使用します。

$worksheet->writeString($row, 1, "テスト", $format);