サンプル


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

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

$worksheet->setRow(0, 45);
$worksheet->setRow(1, 45);

$format1 =& $workbook->addFormat();
$format1->setVAlign('top');
$format2 =& $workbook->addFormat();
$format2->setVAlign('vcenter');
$format3 =& $workbook->addFormat();
$format3->setVAlign('bottom');
$format4 =& $workbook->addFormat();
$format4->setVAlign('vjustify');
$format5 =& $workbook->addFormat();
$format5->setVAlign('vequal_space');

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