# 2、PHPExcel導出  ### html代碼 ~~~ <form class="layui-form layui-col-md12 x-so" action="{:url('admin/fangwei/daochu')}" method="get"> <input type="text" name="fw_pici" value="{$fw_pici ? $fw_pici : '';}" placeholder="請輸入印刷批次" class="layui-input"> <button class="layui-btn"><i class="layui-icon">導出</i></button> </form> ~~~ ### 控制器代碼 ~~~ //導出xls public function daochu(){ //1.從數據庫中取出數據 $where =input('param.fw_pici'); //halt($where); $list = Db('fangwei')->where('fw_pici','=',$where)->order('fw_id ASC')->select(); //halt($list); //2.加載PHPExcle類庫 vendor('PHPExcel.PHPExcel'); //3.實例化PHPExcel類 $objPHPExcel = new \PHPExcel(); //4.激活當前的sheet表 $objPHPExcel->setActiveSheetIndex(0); //5.設置表格頭（即excel表格的第一行） $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A1', 'ID') ->setCellValue('B1', '防偽碼') ->setCellValue('C1', '標簽碼'); //設置A列水平居中 $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment() ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //設置單元格寬度 $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(30); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(30); //6.循環剛取出來的數組，將數據逐一添加到excel表格。 for($i=0;$i<count($list);$i++){ $objPHPExcel->getActiveSheet()->setCellValue('A'.($i+2),$list[$i]['fw_id']);//ID $objPHPExcel->getActiveSheet()->setCellValue('C'.($i+2),$list[$i]['fw_biaoqianma']);//標簽碼 $objPHPExcel->getActiveSheet()->setCellValue('B'.($i+2),$list[$i]['fw_fangweima']);//防偽碼 } //7.設置保存的Excel表格名稱 $filename = '印刷防偽碼'.date('ymd',time()).'.xls'; //8.設置當前激活的sheet表格名稱； $objPHPExcel->getActiveSheet()->setTitle('防偽碼'); //9.設置瀏覽器窗口下載表格 header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header('Content-Disposition:inline;filename="'.$filename.'"'); //生成excel文件 $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); //下載文件在瀏覽器窗口 $objWriter->save('php://output'); exit; } ~~~