Importing Excel Templates

[usernotnull]

I need to open a template xlsx file, and update the table in it.

This is the way I did it so far:

    public static function beforeExport(BeforeExport $event)
    {
        $event->getWriter()->reopen(new LocalTemporaryFile(resource_path('path/to.xlsx')), Excel::XLSX);
    }

When I export, it's exporting to a new sheet.
I would like the export to start from the first sheet instead of adding a new sheet, which will fill the template.
Is there a way to do it?

To circumvent this, I thought about making the fields dynamic, so in the template, sheet 1 table values will reference a new sheet. But this seems hackier...

Also, manually creating the template by code is a LOT of work and won't look as nice, AND is not an easy solution for multiple projects...

[patrickbrouwers]

That's currently the only way to do it.

[usernotnull]

Which way :)
Would really wish there's a way to override the new sheet creation and instead specify the number of an existing sheet.
To jump to phpofffice just for this would be overkill :/

[patrickbrouwers]

public static function beforeExport(BeforeExport $event)
    {
        $event->getWriter()->reopen(new LocalTemporaryFile(resource_path('path/to.xlsx')), Excel::XLSX);
    }

^ this. You probably need to set ->setActiveSheet or something.

It's currently not on our priority to built anything for it, nor support it on open source basis. We can do it on commercial basis https://laravel-excel.com/commercial-support