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