Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class CustomersExportStyling implements FromCollection, WithEvents
- {
- public function collection()
- {
- return User::all();
- }
- public function registerEvents(): array
- {
- return [
- AfterSheet::class => function(AfterSheet $event) {
- // All headers - set font size to 14
- $cellRange = 'A1:W1';
- $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14);
- // Apply array of styles to B2:G8 cell range
- $styleArray = [
- 'bord ers' => [
- 'outline' => [
- 'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
- 'color' => ['argb' => 'FFFF0000'],
- ]
- ]
- ];
- $event->sheet->getDelegate()->getStyle('B2:G8')->applyFromArray($styleArray);
- // Set first row to height 20
- $event->sheet->getDelegate()->getRowDimension(1)->setRowHeight(20);
- // Set A1:D4 range to wrap text in cells
- $event->sheet->getDelegate()->getStyle('A1:D4')
- ->getAlignment()->setWrapText(true);
- },
- ];
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement