サンプル


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

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

$format1 =& $workbook->addFormat();
$format1->setBorder(1);
$format2 =& $workbook->addFormat();
$format2->setBorder(2);
$format3 =& $workbook->addFormat();
$format3->setTop(1);
$format3->setRight(2);

$worksheet->writeString(1, 1, '罫線', $format1);
$worksheet->writeString(3, 1, '太罫線', $format2);
$worksheet->writeString(5, 1, '上と右', $format3);
$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/sample23-1.xls">Excelファイル</a></p>');
print('</body></html>');
?>