php-PhpSpreadsheet设置生成的excel文件列宽度及字体大小

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// 创建新的 Excel 实例
$spreadsheet = new Spreadsheet();
// 获取当前工作表
$worksheet = $spreadsheet->getActiveSheet();
// 设置列宽自动调整的范围
$worksheet->getStyle('B1:C1')->getAlignment()->setWrapText(true);
// 设置要自动调整宽度的行
$worksheet->getColumnDimension('A')->setAutoSize(true);
// 设置要调整宽度的列范围
$worksheet->getColumnDimension('B')->setWidth(20);
$worksheet->getColumnDimension('C')->setWidth(30); 
$worksheet->getStyle('C')->getFont()->setSize(16); //字体大小
// 将 Excel 文件写入到磁盘上
$writer = new Xlsx($spreadsheet);
$writer->save('example.xlsx');