Maats Laraval Excel: Can you export with multiple queries?

Question

I have gone through the docs and also Googled. I see little mention of returning multiple queries on the same sheet from Maat's Laravel Excel. I presume therefore it is 1 query for 1 downloaded spreadsheet. I also presume that if you do have multiple queries that you will need to place each query on an additional sheet.

Have got this right ?

Many thanks

Answer 1

In a perfect world, every query would get its own sheet. But in reality, it will export whatever you give it so long as it receives a single array or collection for the output, depending on your configuration. It would be up to you to determine how to combine your queries into a format that could be interpreted as rows and columns.

Basic example with two queries:

class ExportSample implements FromCollection
{
    // ...

    public function collection()
    {
        // query 1
        $a = User::where('id',2)->get();

        // query 2
        $b = User::where('id',4)->get();

        // merge collections
        return $a->merge($b);
    }    
}

Of course, if your queries result in different column structures, there may be additional obstacles.