phpexcel 导出Demo

最新推荐文章于 2024-07-02 12:16:12 发布

z329982468

最新推荐文章于 2024-07-02 12:16:12 发布

阅读量2.5k

点赞数

分类专栏： php 文章标签： php 函数 phpexcel 导出插件

本文链接：https://blog.csdn.net/u014037646/article/details/51690946

版权

php 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

// 导出excel用户信息
    public function export(){
        $model = D('Common/UserInfo');
        $data = $model -> searchExport();
        $date = date("Y-m-d",time());
        $filename="用户信息表".$date;
        if($data){
            $phpexcel = new \PHPExcel();
            $phpexcel->getActiveSheet()->setTitle($filename);
            $phpexcel->getActiveSheet()
                  ->setCellValue('A1','序号')
                  ->setCellValue('B1','手机号')
                  ->setCellValue('C1','昵称')
                  ->setCellValue('D1','来源')
                  ->setCellValue('E1','UID')
                  ->setCellValue('F1','微博昵称')
                  ->setCellValue('G1','微博UID')
                  ->setCellValue('H1','积分总数')
                  ->setCellValue('I1','用户等级');
            $i =   2;
            foreach ( $data as $k => $val ) {
                $phpexcel->getActiveSheet() 
                         ->setCellValue('A'.$i, $k+1)
                         ->setCellValue('B'.$i, $val['tel'])
                         ->setCellValue('C'.$i, $val['Nick'])
                         ->setCellValue('D'.$i, $val['from'])
                         ->setCellValue('E'.$i, $val['uid'])
                         ->setCellValue('F'.$i, $val['blog'])  
                         ->setCellValue('G'.$i, $val['blog_uid'])  
                         ->setCellValue('H'.$i, $val['integral'])     
                         ->setCellValue('I'.$i, $val['level']);
                $i++;                
    
            }
    
            $obj      = new \PHPExcel_IOFactory();
            $obj_Writer = $obj->createWriter($phpexcel,'Excel5');
            //设置header
            header("Content-Type: application/force-download"); 
            header("Content-Type: application/octet-stream"); 
            header("Content-Type: application/download"); 
            header('Content-Disposition:inline;filename="'.$filename.'.xls"'); 
            header("Content-Transfer-Encoding: binary"); 
            header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); 
            header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
            header("Pragma: no-cache"); 
            $obj_Writer->save('php://output');//输出
        }else{
            $this -> error('系统错误，请稍后重试~');
        }
    }