我们写代码的过程中,生成文档、表格一定是会经常遇到的,而且方法也有很多种,这里列举一种:
include('./Lib/Widget/PHPExcel.php'); array_unshift($mulit_arr, ['这里写表头。。。']); $file_name = '这里写表名'.xls'; $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->fromArray($mulit_arr); //$mulit_arr是表格里的数据,是传过来的数组形式 $objPHPExcel->setActiveSheetIndex(0); header("Pragma: public"); header("Expires: 0"); // set expiration time header("Cache-Component: must-revalidate, post-check=0, pre-check=0"); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$file_name"); header('Content-Transfer-Encoding: binary'); $objwriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objwriter->save('php://output'); exit;
这个方法是珊妹儿个人觉得比较好用的方法,希望能帮助到大家!^_^