ThinkPHP5使用PHPExcel实现数据导出功能

1、将PHPExcel类库文件夹放入extend目录下

2、导出功能实现

 public function download(){

     if(request()->isPost()){

         $val = input('dval','');

         if(!empty($val)){

             $where['phone'] = $val;

         }

         $list = db("withdraw")->where($where)->order('id desc')->select();

         if(empty($list)){

             $this->error('暂无数据打印');

         }

         $data = array();

         foreach ($list as $k=>$value){

             $data[$k]['phone'] = $value['phone'];

             $data[$k]['sl'] = $value['sl'];

             $data[$k]['status'] = $value['status'];

             $data[$k]['createtime'] = date('Y-m-d H:i:s',$value['createtime']);

         }

         foreach ($data as $field=>$v){

             if($field == 'phone'){

                 $headArr[]='手机号';

             }

             if($field == 'sl'){

                 $headArr[]='数量';

             }

             if($field == 'status'){

                 $headArr[]='状态';

             }

             if($field == 'createtime'){

                 $headArr[]='时间';

             }

         }

         $filename="记录";

         return $this->getExcel($filename,$headArr,$data);

     }

 }

 public  function getExcel($fileName,$headArr,$data){

     //导入PHPExcel类库

     require_once(Env::get('root_path') . 'extend/PHPExcel/Classes/PHPExcel.php');

     require_once(Env::get('root_path') . 'extend/PHPExcel/Classes/PHPExcel/IOFactory.php');

     $date = date("Y_m_d",time());

     $fileName .= "_{$date}.xls";

     //创建PHPExcel对象，注意，不能少了\

     $objPHPExcel = new \PHPExcel();

     $objProps = $objPHPExcel->getProperties();

     //设置表头

     $key = ord("A");

     foreach($headArr as $v){

         $colum = chr($key);

         $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);

         $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);

         $key += 1;

     }

     $column = 2;

     $objActSheet = $objPHPExcel->getActiveSheet();

     foreach($data as $key => $rows){ //行写入

         $span = ord("A");

         foreach($rows as $keyName=>$value){// 列写入

             $j = chr($span);

             $objActSheet->setCellValue($j.$column, $value);

             $span++;

         }

         $column++;

     }

     $fileName = iconv("utf-8", "gb2312", $fileName);

     //重命名表

     //$objPHPExcel->getActiveSheet()->setTitle('test');

     //设置活动单指数到第一个表,所以Excel打开这是第一个表

     $objPHPExcel->setActiveSheetIndex(0);

     ob_end_clean();//清除缓冲区,避免乱码

     header('Content-Type: application/vnd.ms-excel');

     header("Content-Disposition: attachment;filename=\"$fileName\"");

     header('Cache-Control: max-age=0');

     $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

     $objWriter->save('php://output'); //文件通过浏览器下载

     exit;

 }