サンプル


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

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

$format1 =& $workbook->addFormat();
$format1->setHAlign('left');
$format2 =& $workbook->addFormat();
$format2->setHAlign('center');
$format3 =& $workbook->addFormat();
$format3->setHAlign('right');
$format4 =& $workbook->addFormat();
$format4->setHAlign('fill');
$format5 =& $workbook->addFormat();
$format5->setHAlign('justify');
$format6 =& $workbook->addFormat();
$format6->setHAlign('merge');
$format7 =& $workbook->addFormat();
$format7->setHAlign('equal_space');

$worksheet->writeString(0, 0, 'ab', $format1);
$worksheet->writeString(1, 0, 'ab', $format2);
$worksheet->writeString(2, 0, 'ab', $format3);
$worksheet->writeString(3, 0, 'ab', $format4);
$worksheet->writeString(0, 1, '東京都千代田区大手町', $format5);
$worksheet->writeString(1, 1, 'ab', $format6);
$worksheet->writeString(2, 1, 'ab c de', $format7);
$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/sample17-1.xls">Excelファイル</a></p>');
print('</body></html>');
?>