PHP导出Excel 之 Spreadsheet

<span></span>php<br><span>//调用Writer.php</span><br><span>require_once</span> '<span>Spreadsheet/Excel/Writer.php</span>';<br><span>//创建Workbook</span><br>$workbook = new Spreadsheet_Excel_Writer();<br><span>//定义导出Excel文件名</span><br>$workbook-><span>send</span>('<span>test.xls</span>');<br><span>//创建Worksheet</span><br>$worksheet =& $workbook->addWorksheet('<span>My first worksheet</span>');<br><span>//设置字体大小</span><br>$format_column = & $workbook->addformat(<span>array</span>('<span>Size</span>'=>9,'<span>Bold</span>'=>1));<br><span>//数据写入</span><br><span>//标题行(第一行)</span><br>$worksheet-><span>write</span>(0, 0, '<span>Name</span>', $format_column);<br>$worksheet-><span>write</span>(0, 1, '<span>Age</span>', $format_column);<br><span>//第一个人(第二行)</span><br>$worksheet-><span>write</span>(1, 0, '<span>John Smith</span>');<br>$worksheet-><span>write</span>(1, 1, 30);<br><span>//第二个人(第三行)</span><br>$worksheet-><span>write</span>(2, 0, '<span>Johann Schmidt</span>');<br>$worksheet-><span>write</span>(2, 1, 31);<br><span>//第三个人(第四行)</span><br>$worksheet-><span>write</span>(3, 0, '<span>Juan Herrera</span>');<br>$worksheet-><span>write</span>(3, 1, 32);<br><span>//关闭Workbook</span><br>$workbook-><span>close</span>();<br><span>?></span>