我正在使用 PHPSpreadsheet 創(chuàng)建和 excel 文件當我填充我的數(shù)據(jù)時它不會傳遞列 'Z' 當對于此查詢我的數(shù)據(jù)實際上有 81 列時。下面是我的代碼：$spreadsheet = new Spreadsheet();$sheet = $spreadsheet->getActiveSheet();$sheet->getDefaultColumnDimension()->setWidth(19);$sheet->getStyle('A:ZZ')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT);$sheet->getStyle('A:ZZ')->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);// $sheet->getStyle('A:U')->getAlignment()->setWrapText(true);$sheet->getStyle('A1:ZZ1')->applyFromArray($headerStyleArray);$sheet->getStyle('A:ZZ')->applyFromArray($fontArray);// SET EXCEL HEADER &COLUMN WIDTH TO AUTOSIZE$i=0;foreach (range('A', $spreadsheet->getActiveSheet()->getHighestDataColumn()) as $col) { $spreadsheet->getActiveSheet() ->getColumnDimension($col) ->setAutoSize(true); $sheet->getCell($col.'1')->setValue($header[$i]); if($i >= count($header)-1) { break; } $i++;} // SET EXCEL CELL DATA$rowNumber = 2;foreach($rows as $row) { $i = 0; foreach (range('A', $spreadsheet->getActiveSheet()->getHighestDataColumn()) as $char) { return response()->json($char.$rowNumber); if($i <= count($row)-1) { $sheet->getCell($char.$rowNumber)->setValue($row[$i]); } $i++; } $rowNumber++;}$writer = new Xlsx($spreadsheet);header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="'. $request->group_name. ' Member Attendance Report.xlsx"');header('Cache-Control: max-age=0');$writer->save('php://output');return;
1 回答
開心每一天1111
TA貢獻1836條經(jīng)驗 獲得超13個贊
改變
foreach (range('A', $spreadsheet->getActiveSheet()->getHighestDataColumn()) as $col) {
}
至
$max_column = $spreadsheet->getActiveSheet()->getHighestDataColumn();
for($column = 'A'; !isBiggerExcelColumn($column,$max_column); ++$column){
// rest of your code
}
function isBiggerExcelColumn($current_column,$max_column){
if(strlen($current_column) < strlen($max_column)) return false;
return strlen($current_column) > strlen($max_column) || strcmp($current_column,$max_column) > 0;
}
在上面，我們使用++$column轉到 PHP 提供的用于遞增字符串的下一個 excel 列。在 中isBiggerExcelColumn()，我們使用 amd 和其他長度檢查進行字符串比較strcmp，以判斷當前列是否大于最大列。如果是，停止循環(huán)，否則繼續(xù)；
- 1 回答
- 0 關注
- 126 瀏覽
添加回答
舉報
0/150
提交
取消