格式记录:
$sheet = $spreadsheet->getActiveSheet();
// 合并单元格
$sheet->mergeCells('A1:L1');
// 设置单元格值
$sheet->setCellValue('A1',$value);
//设值行高
$sheet->getRowDimension('1')->setRowHeight(16);
//设置字体大小
$sheet->getCell('A1')->getStyle()->getFont()->setSize(12);
//设置所有字体
$spreadsheet->getDefaultStyle()->getFont()->setName('微软雅黑');
//设置水平默认对齐方式
$spreadsheet->getDefaultStyle()->getAlignment()
->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
//设置垂直默认对齐方式
$spreadsheet->getDefaultStyle()->getAlignment()
->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
//设置外边框和内边框
$styleArray = [
'borders' => [
'outline' => [
'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
],
'inside' =>[
'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
]
],
];
$sheet->getStyle('A1:L20')->applyFromArray($styleArray);
//设置列宽
$spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(14);
//设置单元格为文本格式
$sheet->getCell('A'.$row)->getStyle()->getNumberFormat()->setFormatCode(NumberFormat::FORMAT_TEXT);
//新增一个sheet
$sheet = $spreadsheet->createSheet();
//设置字体颜色
$sheet->getCell("B$startRow")->getStyle()->getFont()
->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
//字体加粗
$sheet->getCell("A$startRow")->getStyle()->getFont()->setBold(true);
//设置单元格背景色
$spreadsheet->getActiveSheet()->getStyle($column .($beginRow))->getFill()
->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
->getStartColor()->setARGB('FF9800');
//设置公式
$sheet->setCellValue(
"C1",
"=SUM(F1:F10)"
);