サンプル


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

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

for ($i = 0; $i < 4; $i++){
  for ($j = 0; $j < 6; $j++){
    $no = $i * 6 + $j;
    if ($no <= 18){
      $format1 =& $workbook->addFormat();
      $format1->setFgColor('green');
      $format1->setPattern($no);
      $worksheet->write($i, $j, "P.$no", $format1);

      $format2 =& $workbook->addFormat();
      $format2->setFgColor('green');
      $format2->setBgColor('red');
      $format2->setPattern($no);
      $worksheet->write($i + 5, $j, "P.$no", $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/sample16-1.xls">Excelファイル</a></p>');
print('</body></html>');
?>