サンプル


<?php
// 作成日 2008/09/30
require_once("Spreadsheet/Excel/Writer.php");

$workbook = new Spreadsheet_Excel_Writer('./sheet/sample13-1.xls');

$format1 =& $workbook->addFormat();
$format1->setColor('red');

$format2 =& $workbook->addFormat();
$format2->setColor(38);

$worksheet =& $workbook->addWorksheet('シート1');

$worksheet->writeString(0, 0, 'バナナ', $format1);
$worksheet->writeNumber(0, 1, 86, $format2);
$worksheet->writeString(1, 0, 'メロン', $format1);
$worksheet->writeNumber(1, 1, 240, $format2);
$workbook->close();

print('<html>');
print('<head>');
print('<meta http-equiv="Content-Type" content="text/html;charset=Shift_JIS" />');
print('</head>');
print('<body>');
print('<p><a href="./sheet/sample13-1.xls">Excelファイル</a></p>');
print('</body></html>');
?>