作者：乔山办公网日期：
返回目录：office365
ng under flashing brilliant colo
until you feel warm before
< ?php
//调用Writer.php
require_once ‘Spreadsheet/Excel/Writer.php’;
//创建Workbook
$workbook = new Spreadsheet_Excel_Writer();
//定义e5a48de588b67a686964616f338导出Excel文件名
$workbook->send(’test.xls’);
//创建Worksheet
$worksheet =& $workbook->addWorksheet(’My first worksheet’);
//设置字体大小
$format_column = & $workbook->addformat(array(’Size’=>9,’Bold’=>1));
//数据写入
//标题行(第一行)
$worksheet->write(0, 0, ‘Name’, $format_column);
$worksheet->write(0, 1, ‘Age’, $format_column);
//第一个人(第二行)
$worksheet->write(1, 0, ‘John Smith’);
$worksheet->write(1, 1, 30);
//第二个人(第三行)
$worksheet->write(2, 0, ‘Johann Schmidt’);
$worksheet->write(2, 1, 31);
//第三个人(第四行)
$worksheet->write(3, 0, ‘Juan Herrera’);
$worksheet->write(3, 1, 32);
//关闭Workbook
$workbook->close();
?>
spread sheet就是试算表，Microsoft office Excel 很容易用;