PHP导出Excel

首先找到拓展类PHPExcel

链接：https://pan.baidu.com/s/1BgSZ8rHkYm3MJKZu7_FZDg 

提取码：mdi7

封装方法

private  function getExcel($fileName,$headArr,$data)
{
   
    $date = date("Y_m_d",time());
    $fileName .= "_{$date}.xls";    
    
    //导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
    import("Org.Util.PHPExcel"); 
    import("Org.Util.PHPExcel.Writer.Excel5");
    import("Org.Util.PHPExcel.IOFactory.php");

    //创建PHPExcel对象
    $objPHPExcel = new \PHPExcel();
    $objProps = $objPHPExcel->getProperties();

    //设置表头
    $key = ord("A");
    //print_r($headArr);exit;
    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();

    //print_r($data);exit;
    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, 'Excel5');
    $objWriter->save('php://output'); //文件通过浏览器下载
    exit;
}

调用实例

   //   导出数据excel
   public function export(){


      // $data 数据源
         

       header("Content-Type: text/html;charset=utf-8");
       $goods = M('fuser');
       $res = $goods->order('creat_time desc')->select();
       $peo=M('lv');

       foreach($res as $key=>$value){
           $ids = $value['from'];
           $name = $peo->where("id=$ids")->select();
           $value['fname']=$name[0]['name'];
           $res[$key]['fname']=$value['fname'];
       }

        foreach ($res as $k=>$goods_info){

            $data[$k]['id'] = $goods_info['id'];
            $data[$k]['companyname'] = $goods_info['companyname'];
            $data[$k]['name'] = $goods_info['name'];
            $data[$k]['phone'] = $goods_info['phone'];
            $data[$k]['peo'] =$goods_info['fname'];
            $data[$k]['creat_time'] = date('Y-m-d',$goods_info['creat_time']);
        }

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

            if($field == 'id'){
                $headArr[]='ID';
            }

            if($field == 'companyname'){
                $headArr[]='公司名称';
            }
            if($field == 'name'){
                $headArr[]='客户姓名';
            }


            if($field == 'phone'){
                $headArr[]='客户手机号';
            }

            if($field == 'peo'){
                $headArr[]='客户来源';
            }

            if($field == 'creat_time'){
                $headArr[]='客户录入时间';
            }

        }

       //$headArr 列
        //$Data 数据

        $filename="企业宝数据";//文件名

        getExcel($filename,$headArr,$data);

    }