ThinkPHP5.1 PHPExcel 数据导出excel

public function getDaochu(){
        //数据库中查询出的数据
        $data= Db::table('fwm_list')->select();
        //new一个表
        $objExcel = new \PHPExcel();
        $objWriter = \PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
        // 设置水平垂直居中

        $objExcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

        $objExcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        // 字体和样式
        $objExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
        $objExcel->getActiveSheet()->getStyle('A2:AB2')->getFont()->setBold(true);
        $objExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
        // 第一行、第二行的默认高度
        $objExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
        $objExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
        //设置某一列的宽度
        $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
        $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
        $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);

        //  合并
        $objExcel->getActiveSheet()->mergeCells('A1:E1');
        $objActSheet = $objExcel->getActiveSheet(0);
        $objActSheet->setTitle('防伪码表');//设置excel的标题
        $objActSheet->setCellValue('A1','防伪码表');
        $objActSheet->setCellValue('A2','ID');
        $objActSheet->setCellValue('B2','防伪码');
        $objActSheet->setCellValue('C2','分类');
        $objActSheet->setCellValue('D2','添加时间');
        $objActSheet->setCellValue('E2','验证次数');
        //数据从第三行开始往下输出,这里是避免头信息被覆盖(根据自己的表设置更改).
        $Row = 3;
        foreach ( $data as $k => $v ) {
            $i = $Row + $k;
            $objExcel->getActiveSheet()->setCellValue('A'.$i,$v['id']);
            $objExcel->getActiveSheet()->setCellValue('B'.$i,$v['fwm_content']);
            $objExcel->getActiveSheet()->setCellValue('C'.$i,$v['fwm_type']);
            $objExcel->getActiveSheet()->setCellValue('D'.$i,$v['fwm_addtime']);
            $objExcel->getActiveSheet()->setCellValue('E'.$i,$v['fwm_state']);
        }
        $objExcel->setActiveSheetIndex(0);
        //4、输出
        $objExcel->setActiveSheetIndex();
        $time=date('YmdHis');
        ob_end_clean();//清除缓冲区,避免乱码
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=防伪码$time.xls");//告诉浏览器将输出文件的名称
        header('Cache-Control: max-age=0');
        $objWriter->save('php://output');
    }
    ```
    原文：https://www.1949la.com/post/56.html