PHP 导出excel表格 支持无限列+冻结首航

//导出excel表格 无限列 冻结首航  $saveType 1:给前端返回文件流 2保存到本地 $fileName 文件名 $headArr 首行的标题 $data 导出的数据

function getExcelOutByInfiniteColumnsOfFreezePane($saveType,$fileName, $headArr, $data)
{
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();
    $date = date("Y-m-d",time());
    $fileName .= "_".$date.".xlsx";
    //设置单元格内容
    $titCol = 'A';
    foreach ($headArr as $value) {
        // 单元格内容写入
        $sheet->setCellValue($titCol . '1', $value);
        $sheet->getColumnDimension($titCol)->setWidth(20);
        $titCol++;
    }
    $sheet->freezePane('A2');
    $row = 2; // 从第二行开始
    foreach ($data as $key =>$item){
        $dataCol = 'A';
        foreach ($item as $keyName =>$value){
            // 单元格内容写入
            $sheet->setCellValue($dataCol . $row, $value);
            $dataCol++;
        }
        $row++;
    }
    if ($saveType == 1){
        // Redirect output to a client’s web browser (Xlsx)
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename='.$fileName);//01simple.xlsx
        header('Cache-Control: max-age=0');
        // If you're serving to IE 9, then the following may be needed
        header('Cache-Control: max-age=1');
        // If you're serving to IE over SSL, then the following may be needed
        header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
        header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
        header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
        header('Pragma: public'); // HTTP/1.0
        $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
        $writer->save('php://output');
        exit;
    }else{
        $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
        $writer->save($fileName);
        return $fileName;
    }
}