Dynamic properties in Export ?

[tiipiik]

In old versions of Laravel-Excel we could specify properties when creating new Sheet like this :

return \Excel::create($sheet_title, function($excel)
            use ($var, $type, $sheet_title, $page_title) {
            $excel->setTitle($sheet_title)
                ->setCreator('My creator')
                ->setCompany('My company')
                ->sheet($page_titlefunction($sheet) use ($var) {
                    $sheet->loadView('exports.view', ['var' => $var]);
                });
        })->download('my file.xls');

In version 3 and 3.1 I can't figure how to do the same.
I have checked the properties function inside the Export file, but I need to change those properties inside public function view(): View {}, what am I missing ?

[patrickbrouwers]

Please see the example here: https://docs.laravel-excel.com/3.1/exports/extending.html#events

[patrickbrouwers]

Just handle

// Here is the logical where I should redefine the document name.
 // Because name is recomposed from different elements defined here.

In the constructor and put them in protected $title and protected $tires` properties.

[patrickbrouwers]

Alternativly you can also write the properties in the "After" event.

public function view(): View
    {
$this->title = 'New title'

[patrickbrouwers]

            AfterSheet::class => function(AfterSheet $event) {
                $event->writer->getProperties()->setTitlte($this->title ); // or $event->getConcernable()->title;
            },

[patrickbrouwers]

I use this library to make exports of data sets filtered by different kind of fileds, and in order ot make things more clear for the end user I use one of those fields to name the file exported, so he doesn't have to maange with 10 'model.xlsx' files, when all the files have a various content. I don't think it's something specific and it should append ra lot with backend applciations, so I don't understand why this library should not be made for making this kind of stuff.

Id' personally handle all of that logic in a service and pass all the data you need through the constructor

new YourExport($title, $tires, ...)

[tiipiik]

Oh yeah, sometimes I'm so stupid !
Many thanks :)