phpExcel 类导出excel表格

前端代码：
用的是链接按钮
导出Excel
后台代码：
首先引入类
use PHPExcel_IOFactory;
use PHPExcel;
//导出excel
public function export(){
$PHPExcel = new PHPExcel(); //设置表格样式$PHPExcel->setActiveSheetIndex(0)
->setCellValue(‘A1’, ‘名称’)
->setCellValue(‘B1’, ‘状态’)
->setCellValue(‘C1’, ‘类型’);
$data = db(‘sem_plan’)->select();$i=2; //定义一个i变量，目的是在循环输出数据是控制行数
$count = count($data);
//计算有多少条数据
for ($i = 2;$i <= $count+1;$i++) {
$PHPExcel->getActiveSheet()->setCellValue('A' .$i, $data[$i-2][tgjhmc]);
$PHPExcel->getActiveSheet()->setCellValue('B' .$i, $data[$i-2][tgjhzt]);
$PHPExcel->getActiveSheet()->setCellValue('C' .$i, $data[$i-2][jhlx]);
}
$PHPExcel->getActiveSheet()->setTitle(‘user’); //设置sheet的名称$PHPExcel->setActiveSheetIndex(0);
//设置sheet的起始位置
$objWriter = PHPExcel_IOFactory::createWriter($PHPExcel, ‘Excel5’);
//Excel2003通过PHPExcel_IOFactory的写函数将上面数据写出来
$PHPWriter = PHPExcel_IOFactory::createWriter($PHPExcel,”Excel2007”);
//Excel2007
header(‘Content-Disposition: attachment;filename=”表名.xlsx”’);
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’);
$PHPWriter->save(“php://output”);

}