一、导出表格注意点
1.数字导出变成科学公式
参数两边加上 ”\t“
$worksheet->setCellValue('C' . $hang, "\t" . $v['title'] . "\t");
2.内外边框线
表格格式
$styleOneArray = [
'alignment' => [
'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER, // 水平居中
'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER //垂直居中
],
'font' => ['bold' => true], // 字体加粗
];
$worksheet->getStyle('A1' . ':D' . $hang)->applyFromArray($styleOneArray);
$worksheet->getStyle('A1' . ':D' . $hang)->applyFromArray($styleTwoArray);
3. 自动换行
$excel->getActiveSheet()->getStyle('A1:D' . $hang)->getAlignment()->setWrapText(true);