准备材料:
PHPExcel 类
示例代码:
方法一
<?php
$dir = "D:/ws/xampp/PHPExcel/PHPExcel/PHPExcel.php";//找到当前 PHPExcel 脚本所在路径
require $dir;//引入文件
$new_dir = "D:/ws/xampp/xampp/htdocs/mysite";//导出文件路径
$objPHPExcel = new PHPExcel();//实例化PHP类,等同于在桌面上新建一个excel表格
$objSheet = $objPHPExcel->getActiveSheet();//获得当前活动sheet的操作对象
$objSheet->setTitle("demo");//给当前活动sheet设置名称
$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分数");//给当前活动sheet填充数据
$objSheet->setCellValue("A2","张三")->setCellValue("B2","50");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");//按照指定格式生成excel文件(该例为 Excel2007 格式)
$objWriter->save($new_dir."/demo.xlsx");//保存(导出)文件
?>
方法二(用数组的方式输入数据)
<?php
$dir = "D:/ws/xampp/PHPExcel/PHPExcel/PHPExcel.php";//找到当前脚本所在路径
require $dir;//引入文件
$new_dir = "D:/ws/xampp/xampp/htdocs/mysite";
$objPHPExcel = new PHPExcel();//实例化PHP类,等同于在桌面上新建一个excel表格
$objSheet = $objPHPExcel->getActiveSheet();//获得当前活动sheet的操作对象
$objSheet->setTitle("demo");//给当前活动sheet设置名称
/**$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分数");//给当前活动sheet填充数据
$objSheet->setCellValue("A2","张三")->setCellValue("B2","50");**/
$array = array(
array(),//第一行为空
array("","姓名","分数"),//第一列为空
array("","李四","60"),
array("","王五","70")
);
$objSheet->fromArray($array);//直接加载数组来填充数据
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");//按照指定格式生成excel文件
$objWriter->save($new_dir."/demo.xlsx");
?>