phpoffice--表格设置

//居中

$sheet->setCellValue('A1','你好')->getStyle('A1')->getAlignment()->setHorizontal(\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);

//自动设置行宽（没有合并列下）

$sheet->setCellValue('A','你好')->getColumnDimension('A')->setAutoSize(true);

//自体加粗

$sheet->setCellValue('A1','你好')->getStyle('A1')->getFont()->setBold(true);

//合并单元格

$sheet->mergeCells('A1:L2');