サンプル


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

$workbook = new Spreadsheet_Excel_Writer('./sheet/sample28-1.xls');
$worksheet =& $workbook->addWorksheet('シート1');

$worksheet->setColumn(1, 2, 15);
$worksheet->setColumn(3, 3, 8, 0, 1);

$worksheet->writeString(1, 1, 'バナナ');
$worksheet->writeNumber(1, 2, 120);
$worksheet->writeString(1, 3, '3個');
$worksheet->writeString(2, 1, 'トマト');
$worksheet->writeNumber(2, 2, 86);
$worksheet->writeString(2, 3, '8個');
$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/sample28-1.xls">Excelファイル</a></p>');
print('</body></html>');
?>