Laravel Excel : Styling table import

Photo by Mika Baumeister on Unsplash

Menambahkan Garis Border pada Excel

Tambahkan code style berikut :

class UserExportFile implements FromView, ShouldAutoSize, WithStyles {
    public function styles(Worksheet $sheet)
    {
        $styleArray = [
            'borders' => [
                'allBorders' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
                    'color' => ['argb' => '000000'],
                ],
            ],
        ];

        $sheet->getStyle('A8:D20')->applyFromArray($styleArray);

    }
}