导出文件实例

 1 <?php 
 2 
 3 //引入PHPExcel文件
 4 require "./PHPExcel.php";
 5 
 6 //实例化PHPExcel对象
 7 $objExcel = new PHPExcel();
 8 
 9 //获得当前sheet内置表
10 $obj = $objExcel->getActiveSheet();
11 
12 //填充数据
13 $obj->setCellValue(‘A1‘,‘姓名‘)->setCellValue(‘B1‘,‘分数‘);
14 $obj->setCellValue(‘A2‘,‘张三‘)->setCellValue(‘B2‘,‘80‘);
15 $obj->setCellValue(‘A3‘,‘李四‘)->setCellValue(‘B3‘,‘90‘);
16 
17 //按照指定格式生成excel文件
18 $objWriter = PHPExcel_IOFactory::createWriter($objExcel,‘Excel2007‘);
19 $objWriter->save("./demo.xlsx");
20 
21 
22  ?>