Laravel Excel export multiple sheets to xlsx and pdf (landscape)

have you tried what they have listed here, https://stackoverflow.com/questions/57619785/laravel-maatwebsite-excel-phpspreadsheet-and-tcpdf-wrong-sheet-orientation

also some info here about paging, https://github.com/Maatwebsite/Laravel-Excel/issues/537

Yeah I've tried the following in the export class:

    /**
     * @param \Maatwebsite\Excel\Events\AfterSheet $event
     */
    public static function afterSheet(AfterSheet $event)
    {
        $event->sheet->getDelegate()->getPageSetup()
            ->setOrientation(PageSetup::ORIENTATION_LANDSCAPE)
            ->setPaperSize(PageSetup::PAPERSIZE_A4);
    }

Turns out that the afterSheet event is not being triggerd, anyone got ideas why not?

Updated simplified code:

<?php

use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\RegistersEventListeners;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
use Maatwebsite\Excel\Events\AfterSheet;
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;

class ComposerStatementExport implements WithEvents, WithMultipleSheets
{
    use Exportable, RegistersEventListeners;

    /**
     * @return array
     */
    public function sheets(): array
    {
        $sheets = [
            new OverviewSheet($this->statements)
        ];

        $this->statements->each(function ($statement) use (&$sheets) {
            $sheets[] = new StatementSheet($statement);
        });

        return $sheets;
    }

    /**
     * @param \Maatwebsite\Excel\Events\AfterSheet $event
     */
    public static function afterSheet(AfterSheet $event)
    {
        $event->sheet->getDelegate()->getPageSetup()
            ->setOrientation(PageSetup::ORIENTATION_LANDSCAPE)
            ->setPaperSize(PageSetup::PAPERSIZE_A4);
    }
}

<?php

class DownloadController
{
    public function __invoke()
    {
        $formats = ['xlsx', 'pdf'];

        $export = new StatementExport($statements);

        foreach ($this->formats as $format) {
            $files[] = $this->store($export, $format);
        }

        Auth::user()->notify(new Download($files));
    }

    protected function store(ComposerStatementExport $export, $format)
    {
        $name = "statement.{$format}";

        switch ($format) {
            case 'xlsx':
                $type = Excel::XLSX;
                break;

            case 'pdf':
                $type = Excel::DOMPDF;
                break;

            default:
                // TODO: Exception
                break;
        }

        $export->store($name, null, $type);

        return Storage::path($name);
    }
}

So it's saving your pdf but it's not orienting it as landscape? And there's no error message?

The first thing I would do is this

dd ($event);

Within your after sheet method.

Also, when I use PHP office it usually requires me to save the workbook, but I don't know about this.

Yes, no errors. Also the dd is not showing in the event, so I think the problem could be with the event not being fired...

dd isn’t firing or it is showing $event as null?

dd inside the event isn't firing.

I would try putting this somewhere, just to test:

$this->afterSheet($param);

Found the issue: there is no afterSheet on multipleSheets. I moved the events to the single sheets and now it works.

Thanks!

I nominate CliffordJames for best answer. :P