thinkphp6 生成下载动态Excel模板,导出excel文件

1，安装 phpexcel

composer require phpoffice/phpexcel

安装成功后，vendor文件夹下会有phpoffice文件夹

2，common.php 中加入导出excel方法

function tbld_createExcel($title = '',$name=array(),$data=array()) {
    $excel_data = array();
    foreach ($name as $val){
        $excel_data[0][] = array('data' =>$val);
    }
    foreach ($data as $val){
        $tmp = array();
        foreach ($val as $v){
            $tmp[]['data']=$v;
        }
        $excel_data[]=$tmp;
    }
    $objPHPExcel=new \PHPExcel();
    $header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
    foreach ($excel_data as $k=>$val){
        $topcount=count($val);
        for ($i = 0; $i <= $topcount-1; $i++) {
            if($val[$i]['data']==''){$excelval='';}else{$excelval=$val[$i]['data'];}
            $objPHPExcel->getActiveSheet()->setCellValue($header_arr[$i].($k+1),$excelval)->getStyle($header_arr[$i].($k+1));
        }
    }
    $objPHPExcel->getActiveSheet()->setTitle($title);
    $objPHPExcel->setActiveSheetIndex(0);
    $objPHPExcel->getDefaultStyle()->getFont()->setName('宋体')->setSize(12);
    $exname=$title.date('Y-m-d-H-i-s');
    $PHPWriter = \PHPExcel_IOFactory::createWriter( $objPHPExcel,"Excel2007");
    header("Content-Disposition: attachment;filename=".$exname.".xlsx");
    header('Content-Type:text/html; charset=utf-8');
    $PHPWriter->save("php://output");
    exit();
}

3，怎么用这个方法

$excelname=array('姓名','性别','年龄');
$exceldata=array( ['（例）小明','男','18']);
tbld_createExcel('会员导入模板',$excelname,$exceldata);