/** * Autosize column for document * @param LaravelExcelWorksheet $sheet * @return LaravelExcelWorksheet */ public function autosizeColumn($sheet) { if ($columns = $sheet->getAutosize()) { if (is_array($columns)) { $sheet->setAutoSize($columns); } else { $toCol = $sheet->getHighestColumn(); $toCol++; for ($i = 'A'; $i !== $toCol; $i++) { $sheet->getColumnDimension($i)->setAutoSize(true); } $sheet->calculateColumnWidths(); } } return $sheet; }