TP5在使用PhpSpreadsheet时列数超过26列会报错,具体解决方法如下,亲测好用
QQ961052877
//写入表头部分改为
// 设置表头
//$head格式为['姓名','电话','联系方式']
$colum = 'A';
foreach ($head as $v) {
$sheet->setCellValue($colum . '1', $v);
$sheet->getColumnDimension($colum)->setWidth(20);
$colum++;
}
//写入内容改为
$column = 2;
foreach ($data as $key => $rows) {
$span = 'A';
// 列写入
foreach ($rows as $keyName => $value) {
$sheet->setCellValue($span . $column, $value);
$span++;
}
$column++;
}