Basic PDF support

[pxlrbt]

From Discord:

Hi Dennis, I hope you're doing well. I just wanted to let you know that I was able to landscape the PDF using the event as you suggested. Thank you for your help!
Here are the code I have used:

Sheet::listen(BeforeSheet::class, function ($sheet) {
            $sheet->getDelegate()->getPageSetup()->setOrientation(\PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);

            $sheet->getDelegate()->getStyle('1')->getFont()->setSize(8);
        });

However, you can use the RegistersEventListeners trait to automatically register the event listeners. To do so, simply add the trait to your class and include this function within your class:

beforeSheet(BeforeSheet $event)
    {
         $event->sheet->getDelegate()->getPageSetup()->setOrientation(\PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
    }

or you can just add this one in your Page without trait

public function boot()
    {
        Sheet::listen(BeforeSheet::class, function ($sheet) {
            $sheet->getDelegate()->getPageSetup()->setOrientation(\PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);

            $sheet->getDelegate()->getStyle('1')->getFont()->setSize(8);
        });
    }

[jimiero]

@pxlrbt i'm using this on my resource table

->headerActions([
                ExportAction::make('pdf')
                    ->label('PDF')
                    ->color('gray')
                    ->exports([
                        ExcelExport::make()->withWriterType(\Maatwebsite\Excel\Excel::TCPDF)->label('PDF')->fromTable()->withFilename('my-resource.pdf'),
                    ])
            ])

how can i change that to provide the pdf orientation when it exports to pdf my table?

[pxlrbt]

Did you try the approach mentioned above?
I never exported to PDF via Maatswebsite\Excel package, so I can't tell more.

[jimiero]

I don't know where exactly to use the code above, and I'm not using a custom export as you see my action above

[pxlrbt]

Either to a ServiceProvider (first example) or your page class (third example)

[jimiero]

thanks, works using ServiceProvider, but now i have another issues 🤦 the table column widths get too big and the pdf doesn't look fine.. any idea if I can shrink those inside the pdf?

[pxlrbt]

Sorry, as I said, I never used the PDF export before, so I can't really help with this.