Generating csv file with Maatwebsite/Laravel-Excel how make headings returns dynamic array

Question

In laravel 5.8 generating csv file I use https://github.com/Maatwebsite/Laravel-Excel plugin and it works ok, but as I use headings method for header generating https://docs.laravel-excel.com/3.1/exports/mapping.html

I need to have headers depending on result set I got from the db :

<?php

namespace App\Exports;

use Auth;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class exportSearchResults implements FromCollection, WithHeadings
{
    public function collection()
    {
        $searchResultRows = SearchResult
            ::getByUserList($this->user_list_id)
            ->select( 'source_id' )
            ->groupBy( 'source_id' )
            ->orderBy('source_id', 'asc')
            ->get()
            ->toArray();
            ...
        return $searchResultRows;
    }

    public function headings(): array
    {
        return [
            'field',
            'value',
        ];
        // I need Somehow to return content of this array based on $searchResultRows array in collection method
    }

}

Is there is such way ?

mare96 · Accepted Answer · 2019-06-24 15:25:48Z

3

You can use something like this:

<?php

namespace App\Exports;

use Auth;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class exportSearchResults implements FromCollection, WithHeadings
{
    private $searchResultRows;

    public function collection()
    {
        return $this->searchResultRows;
    }


    public function headings(): array {
         $this->searchResultRows = SearchResult::getByUserList($this->user_list_id)
            ->select( 'source_id' )
            ->groupBy( 'source_id' )
            ->orderBy('source_id', 'asc')
            ->get()
            ->toArray();
            ...
        if ($this->searchResultRows ...){
        return [
            'field',
            'value',
        ];
        } else {
          return ...
        }
    }

}

edited Jun 24, 2019 at 15:25

answered Jun 24, 2019 at 13:23

mare96

3,8541 gold badge22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

sam_bossom Over a year ago

I try this way, but debugging with logging looks method headings is called at first and collection after that

mare96 Over a year ago

You can also try beforeExport. I didnt use it but give a try..

sam_bossom Over a year ago

To read data twice nto get separately data and headers? Yes that could work.

mare96 Over a year ago

Maybe you can do like this. Check update. To avoid DRY.

Collectives™ on Stack Overflow

Generating csv file with Maatwebsite/Laravel-Excel how make headings returns dynamic array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related