<?php // 作成日 2008/09/29 require_once("Spreadsheet/Excel/Writer.php"); $workbook = new Spreadsheet_Excel_Writer('./sheet/sample10-1.xls'); $worksheet =& $workbook->addWorksheet('シート1'); $worksheet->writeNumber(0, 0, 35); $worksheet->writeNumber(0, 1, 45); $worksheet->writeFormula(0, 2, '=SUM(A1:B1)'); $worksheet->writeNumber(1, 0, 58); $worksheet->writeNumber(1, 1, 38); $worksheet->writeFormula(1, 2, '=AVERAGE(A2:B2)'); $worksheet->writeNumber(2, 0, 85); $worksheet->writeNumber(2, 1, 78); $worksheet->writeFormula(2, 2, '=(A3+B3)/2'); $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/sample10-1.xls">Excelファイル</a></p>'); print('</body></html>'); ?>