``` ob_end_clean(); $columns=[ ['month', '月份'], ['acontract_nums', '當月下達合同(協議)數量'], ['production_nums', '月下達產量(噸)'], ['xian_xiada', "西安公司"], ['shandong_xiada', "山東公司"], ['not_acontract_nums', "合同數量"], ['not_production_nums', "待下達量"], ['not_xian_xiada', "西安公司"], ['not_shandong_xiada', "山東公司"], ['year_on_year_growth', "同比增長"], ]; $heji['month']="合計"; $heji['acontract_nums']= ""; $heji['production_nums']= ""; $heji['xian_xiada']= ""; $heji['shandong_xiada']= ""; $heji['not_acontract_nums']= ""; $heji['not_production_nums']= ""; $heji['not_xian_xiada']= ""; $heji['not_shandong_xiada']= ""; $heji['year_on_year_growth']=""; $data[]=$heji; $list['total']=count($data); $list['data']=$data; // 初始化表頭數組 $str = ['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']; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); // foreach ($columns as $k => $v) { // $sheet->setCellValue($str[$k] . '1', $v['1']); // } // $sheet->setCellValue('B1','其中：當月下達')->mergeCells('B1:E1'); $sheet->setCellValue('F1','待下達')->mergeCells('F1:I1'); $sheet->setCellValue('A1','月份')->mergeCells('A1:A2'); $sheet->setCellValue('B2','當月下達合同(協議)數量'); $sheet->setCellValue('C2','月下達產量(噸)'); $sheet->setCellValue('D2','西安公司'); $sheet->setCellValue('E2','山東公司'); $sheet->setCellValue('F2','待下達合同數量'); $sheet->setCellValue('G2','待下達量'); $sheet->setCellValue('H2','西安公司'); $sheet->setCellValue('I2','山東公司'); $sheet->setCellValue('J1','同比增長')->mergeCells('J1:J2'); $list = (isset($list['total']) && isset($list['per_page']) && isset($list['data'])||isset($list['total'])) ? $list['data'] : $list; foreach ($list as $key => $value) { foreach ($columns as $k => $v) { $sheet->setCellValue($str[$k] . ($key + 3), $value[$v['0']]); } } $name ="xxx報表"; header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $name . '導出' . '.xlsx"'); header('Cache-Control: max-age=0'); $writer = new Xlsx($spreadsheet); $writer->save('php://output');//輸出文件標題 ```