PhpOffice相关注意点

一、导出表格注意点

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);

4.单元格添加背景
$worksheet->getStyle('A2:I3')->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('87CEFA');