Laravel Excel PDF export (DOMPDF) header and footer.
Hi,
I am using Laravel Excel 3.1 with DOMPDF writer for pdf export.
I am trying to put header and footer on all pages but it doesn't work.
I have tried the below
public function registerEvents(): array
{
return [
BeforeExport::class => function (BeforeExport $event) {
$event->writer->getProperties()->setTitle($this->title);
},
AfterSheet::class => function (AfterSheet $event) {
$event->sheet->getDelegate()->getPageSetup()->setOrientation(PageSetup::ORIENTATION_LANDSCAPE);
$event->sheet->getDelegate()->getPageSetup()->setPaperSize(PageSetup::PAPERSIZE_A4);
$event->sheet->getDelegate()->getPageMargins()->setLeft(0.3);
$event->sheet->getDelegate()->getHeaderFooter()->setDifferentOddEven(false);
$event->sheet->getDelegate()->getHeaderFooter()->setOddFooter('&R&F Page &P / &N');
}
@Patel Yes. That shows that it can dump it to that format. Not how to interact with the DomPDF package. And as I pointed out, that does not seem to be possible.