1.切记访问方法的时候不能用ajax 要直接url访问 比如前端访问
window.location.href= '/admin/Apply/Compensate/checkCom';
//数据导出excel 的demo public function ExcelDemo(){ //demo测试 //数据库查询的数据 $data=db('safe_apply_pgb_give')->select(); //tp5 的vendor引用 vendor('phpoffice.phpexcel.Classes.PHPExcel'); vendor('phpoffice.phpexcel.Classes.PHPExcel.Writer.IWriter'); vendor('phpoffice.phpexcel.Classes.PHPExcel.Writer.Abstract'); vendor('phpoffice.phpexcel.Classes.PHPExcel.Writer.Excel5'); //excel 为2003版本 vendor('phpoffice.phpexcel.Classes.PHPExcel.Writer.Excel2007'); //excel 为2007版本 可以自己任选一个 vendor('phpoffice.phpexcel.Classes.PHPExcel.Writer.Excel2007.Drawing'); vendor("phpoffice.phpexcel.Classes.PHPExcel.IOFactory"); $objPHPExcel = new \PHPExcel(); //$objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel); $objActSheet = $objPHPExcel->getActiveSheet(); //设置首行的 各列的名称 $objActSheet->setCellValue('A1', 'id') ->setCellValue('B1', 'openid') ->setCellValue('C1', 'nickName') ->setCellValue('D1', 'buyer') ->setCellValue('E1', 'ordertime') ->setCellValue('F1', 'orderdate') ->setCellValue('G1', 'address') ->setCellValue('H1', 'name') ->setCellValue('I1', 'goodid') ->setCellValue('J1', 'img') ->setCellValue('K1', 'oneprice') ->setCellValue('L1', 'num') ->setCellValue('M1', 'color') ->setCellValue('N1', 'sex') ->setCellValue('O1', 'size') ->setCellValue('P1', 'buynum') ->setCellValue('Q1', 'buy') ->setCellValue('R1', 'price') ->setCellValue('S1', 'status') ->setCellValue('T1', 'formkorea') ->setCellValue('U1', 'saddress') ->setCellValue('V1', 'remark') ->setCellValue('W1', 'formchina') ->setCellValue('X1', 'subremark') ->setCellValue('Y1', 'ddh'); // 设置个表格宽度 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(16); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(12); foreach($data as $k=>$v){ $k +=2; $objActSheet->setCellValue('A'.$k, $v['djbh']); $objActSheet->setCellValue('B'.$k, $v['username']); // $objActSheet->setCellValue('C'.$k, $v['content']); if($v['is_pic']==1){ $objDrawing[$k] = new \PHPExcel_Worksheet_Drawing(); $objDrawing[$k]->setPath('.'.$v['content']);//这里拼接 . 是因为要在根目录下获取 // 设置宽度高度 $objDrawing[$k]->setHeight(80);//照片高度 $objDrawing[$k]->setWidth(80); //照片宽度 /*设置图片要插入的单元格*/ $objDrawing[$k]->setCoordinates('C'.$k); // 图片偏移距离 $objDrawing[$k]->setOffsetX(2); $objDrawing[$k]->setOffsetY(12); $objDrawing[$k]->setWorksheet($objPHPExcel->getActiveSheet()); // 表格高度 $objActSheet->getRowDimension($k)->setRowHeight(80); } else{ $objActSheet->setCellValue('C'.$k, $v['content']); } } $fileName = '报价表'; $date = date("Y-m-d",time()); $fileName .= "_{$date}.xls"; $fileName = iconv("utf-8", "gb2312", $fileName); //重命名表 // $objPHPExcel->getActiveSheet()->setTitle('test'); //设置活动单指数到第一个表,所以Excel打开这是第一个表 $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel'); header("Content-Disposition: attachment;filename=\"$fileName\""); header('Cache-Control: max-age=0'); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); //文件通过浏览器下载 }
其实这是模仿以下链接的博客主:
以下有几个很好的链接可以去看看 网上还有很多:
https://www.cnblogs.com/chentailin/p/9345854.html
https://blog.csdn.net/pengone/article/details/47724423
http://www.thinkphp.cn/topic/53674.html