Laravel Export excel font family

I use maatwebsite laravel excel register event to style the sheet, how can I set font family to whole sheet

                $event->sheet
                    ->getPageSetup()
                    ->setOrientation(\PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
                $event->sheet->getDelegate()->getStyle('A1:U3')
                    ->getAlignment()
                    ->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
            },

SilenceBringer

3 years ago

Level 55

@saren um not sure, but I think something like

$event->sheet
	->getStyle()
	->getFont()
	->setName('Arial');

also check https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#styles search for subsection Setting the default style of a workbook

ZandA

3 years ago

Level 1

@SilenceBringer Thank you for reply, how can I use my custom font?

Please or to participate in this conversation.