tp5 phpexcel导出excel表格

来源：互联网发布：淘宝在哪看自己的评价编辑：程序博客网时间：2024/06/05 20:19

下载：PHPExcel https://github.com/PHPOffice/PHPExcel

解压后：Classes文件夹改名为PHPExcel

方法一：然后把PHPExcel文件夹放到根目录vendor文件夹下

//导出    public function studentexport(){$student = db('student')->select();     //数据库查询$path = dirname(__FILE__); //找到当前脚本所在路径 vendor("PHPExcel.PHPExcel"); //方法一$PHPExcel = new \PHPExcel();$PHPSheet = $PHPExcel->getActiveSheet();$PHPSheet->setTitle("demo"); //给当前活动sheet设置名称$PHPSheet->setCellValue("A1", "ID")->setCellValue("B1", "城市编号")->setCellValue("C1", "PATH")->setCellValue("D1", "PCODE")->setCellValue("E1", "城市名");$i = 2;foreach($student as $data){$PHPSheet->setCellValue("A" . $i, $data['id'])->setCellValue("B" . $i, $data['type'])->setCellValue("C" . $i, $data['guishu'])->setCellValue("D" . $i, $data['hezuodanwei'])->setCellValue("E" . $i, $data['name']);$i++;}$PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, "Excel2007");header('Content-Disposition: attachment;filename="表单数据.xlsx"');header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');$PHPWriter->save("php://output"); //表示在$path路径下面生成demo.xlsx文件}

阅读全文

0 0