<!-- 使用PHPExcel导出文件代码实现，PHPExcel探索之旅教程-慕课网 -->

<!-- 视频教程地址：https://www.imooc.com/video/8364 -->

<?php

$dir=dirname(__FILE__); //找到当前脚本所在目录

require $dir."/PHPExcel/PHPExcel.php"; //加载文件

$objPHPExcel=new PHPExcel(); // 实例化PHPEXcel类，等同于在桌面上新建一个excel表格

$objSheet=$objPHPExcel->getActiveSheet(); // 获得当前活动sheet的操作对象

$objSheet->setTitle("demo");// 给当前活动Sheet设置名称，即工作表名

$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分数");// 给当前活动Sheet填充数据

$objSheet->setCellValue("A2","张三")->setCellValue("B2","68");

$objSheet->setCellValue("A3","李四")->setCellValue("B3","80");

$objSheet->setCellValue("A4","王五")->setCellValue("B4","78");

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");// 按照指定格式生成excel文件。

$objWriter->save($dir."/demo.xlsx");

?>

3-2 使用PHPExcel导出文件代码实现

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分数');

$objSheet->setCellValue('A2','张三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

3-2 使用PHPExcel导出文件代码实现

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分数');

$objSheet->setCellValue('A2','张三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分数');

$objSheet->setCellValue('A2','张三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

PHPExcel代码现实现Demo