thinkphp5Excel导出

最新推荐文章于 2025-06-09 20:03:58 发布

置顶顺其自然～

最新推荐文章于 2025-06-09 20:03:58 发布

阅读量184

点赞数

分类专栏： thinkphp5Excel导出文章标签： thinphp5 php thinkphp5Excel导出

本文链接：https://blog.youkuaiyun.com/weixin_44452446/article/details/93708879

版权

thinkphp5Excel导出专栏收录该内容

1 篇文章

订阅专栏

1.需要引用sdk包，可以去文档百度云里下载
链接：https://pan.baidu.com/s/1vIwBAWMkKkHf51a6IfpWxw
提取码：fuie
2.下载的文件放到vendor里(这是tp5专门放置类库文件的)
3.这个是我算格子订的，如果你是多条导出可以写个循环，还有格子的位置都可以直接画的，有兴趣的可以去查查

use PHPExcel_IOFactory;
use PHPExcel;

    public function excel()
     {
        //导出
    //##########################################################################
    $id = input('id');
    if ($id) {
            require_once APP_PATH . '/../vendor/Classes/PHPExcel.php';
            $value = Db::name('basic_info')->where('id',$id)->find();
            // dump($value);
            $file_name = date('Y-m-d_His').'.xls';
            $path = dirname(__FILE__);
            Loader::import('PHPExcel.Classes.PHPExcel');
            Loader::import('PHPExcel.Classes.PHPExcel.IOFactory.PHPExcel_IOFactory');
          
            $PHPExcel = new \PHPExcel();
            // print_r($PHPExcel);die;
            $PHPSheet = $PHPExcel->getActiveSheet();
            $PHPSheet->setTitle("员工信息");
            $PHPSheet->setCellValue("A1","名字");
            $PHPSheet->setCellValue("B1","性别");
            $PHPSheet->setCellValue("C1","出生日期");
            $PHPSheet->setCellValue("D1","录入编号");
            $PHPSheet->setCellValue("E1","外语水平");
            $PHPSheet->setCellValue("F1","外语资格");
            $PHPSheet->setCellValue("G1","婚姻状况");
            $PHPSheet->setCellValue("H1","记入日");
            $PHPSheet->setCellValue("I1","毕业学校");
            $PHPSheet->setCellValue("J1","学位");

            $PHPSheet->setCellValue("A3","户籍");
            $PHPSheet->setCellValue("B3","居住地");
            $PHPSheet->setCellValue("C3","民族");
            $PHPSheet->setCellValue("D3","计算机等级");
            $PHPSheet->setCellValue("E3","职称技能1");
            $PHPSheet->setCellValue("F3","职称技能2");
            $PHPSheet->setCellValue("G3","会计证书确认");
            $PHPSheet->setCellValue("H3","语言资格确认");
            $PHPSheet->setCellValue("I3","职称技能确认");
            $PHPSheet->setCellValue("J3","邮箱");

            $PHPSheet->setCellValue("A5","住址");
            $PHPSheet->setCellValue("B5","责任者");
            $PHPSheet->setCellValue("C5","便携电话");
            $PHPSheet->setCellValue("D5","便携电话2");
            $PHPSheet->setCellValue("E5","情报源");
;
            $i = 2;
            // foreach($list as $key => $value){
                $PHPSheet->setCellValue('A'.$i,''.$value['name']);
                $PHPSheet->setCellValue('B'.$i,''.$value['sex']);
                $PHPSheet->setCellValue('C'.$i,''.$value['birthday']);
                $PHPSheet->setCellValue('D'.$i,''.$value['number']);
                $PHPSheet->setCellValue('E'.$i,''.$value['language_lv']);
                $PHPSheet->setCellValue('F'.$i,''.$value['language_zg']);
                $PHPSheet->setCellValue('G'.$i,''.$value['married']);
                $PHPSheet->setCellValue('H'.$i,''.$value['log_time']);
                $PHPSheet->setCellValue('I'.$i,''.$value['school']);
                $PHPSheet->setCellValue('J'.$i,''.$value['academic_degree']);
            $a = 4;
                $PHPSheet->setCellValue('A'.$a,''.$value['huji']);
                $PHPSheet->setCellValue('B'.$a,''.$value['location']);
                $PHPSheet->setCellValue('C'.$a,''.$value['nation']);
                $PHPSheet->setCellValue('D'.$a,''.$value['computer_lv']);
                $PHPSheet->setCellValue('E'.$a,''.$value['zcjn1']);
                $PHPSheet->setCellValue('F'.$a,''.$value['zcjn2']);
                $PHPSheet->setCellValue('G'.$a,''.$value['kjzsqr']);
                $PHPSheet->setCellValue('H'.$a,''.$value['yyzgqr']);
                $PHPSheet->setCellValue('I'.$a,''.$value['zcjnqr']);
                $PHPSheet->setCellValue('I'.$a,''.$value['email']);
            $b = 6;
                $PHPSheet->setCellValue('A'.$b,''.$value['address']);
                $PHPSheet->setCellValue('B'.$b,''.$value['zrz']);
                $PHPSheet->setCellValue('C'.$b,''.$value['phone']);
                $PHPSheet->setCellValue('D'.$b,''.$value['phone2']);
                $PHPSheet->setCellValue('E'.$b,''.$value['qby']);
                $PHPSheet->setCellValue('F'.$b,''.$value['bz']);
                // $i++;
            // }
            // $PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel,"Excel2007");
                $fileName = iconv("utf-8", "gb2312", $file_name); // 重命名表
                header('Content-Type: application/vnd.ms-excel');
             
                header("Content-Disposition: attachment;filename=$fileName");
             
                header('Cache-Control: max-age=0');
             
                $objWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel5');
             
                $objWriter->save('php://output'); // 文件通过浏览器下载
     
        }else{
            return $this->error('新增不能导出');
        }
    }