Laravel Maatwebsite excel array

Question

I'm a newbie in Laravel, but I'm using laravel's Maatwebsite\Excel Library v3 to export excel. But I'm having some problems exporting my array data.

here is my code

    <?php

namespace App\Exports;
use App\Team;

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

class RegisteredMemberExport implements FromCollection, WithHeadings
{
    use Exportable;

    public function collection()
    {

     $data = Team::where('reg', 1)->get();       

        return collect([
            [
                'name' => $data->name,
                'email' => $data->email
            ]
        ]);
    }

    public function headings(): array
    {
        return [
            'name',
            'email'
        ];
    }

}

the collect should be

return collect
([
            [
                'name' => 'Povilas',
                'email' => '[email protected]'
            ],
            [
                'name' => 'Taylor',
                'email' => '[email protected]'
            ]
        ]);

I can't use a loop inside the collect method return. Can I please have some help?

what data do you want from coolection

Shailendra Gupta
– Shailendra Gupta

2018-09-22 17:37:51 +00:00
Commented Sep 22, 2018 at 17:37 — Shailendra Gupta
– Shailendra Gupta, Commented Sep 22, 2018 at 17:37
What would you want to do with the loop?

Elisha Senoo
– Elisha Senoo

2018-09-22 19:09:30 +00:00
Commented Sep 22, 2018 at 19:09 — Elisha Senoo
– Elisha Senoo, Commented Sep 22, 2018 at 19:09

Reda Bezzerrouki · Accepted Answer · 2018-09-22 18:36:57Z

2

You can directly filter the values you need from your Eloquent model using a list of attributes as a parameter for the get method.

$data = Team::where('reg', 1)->get(['name', 'email']);

return collect($data->toArray());

edited Sep 22, 2018 at 18:36

answered Sep 22, 2018 at 18:23

Reda Bezzerrouki

3813 silver badges4 bronze badges

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

Comments

TheGeeky · Accepted Answer · 2018-09-22 15:55:11Z

0

You can use each or map or any chain method you want Laravel Collections like this:

return collect([
                 ['name' => 'Povilas','email'=>'[email protected]'],
                 ['name' => 'Taylor','email' => '[email protected]']
              ])->each(function($value){
                 return $value; // Do what you want here
         });

answered Sep 22, 2018 at 15:55

TheGeeky

9711 gold badge13 silver badges35 bronze badges

Comments

bmatovu · Accepted Answer · 2019-06-26 08:57:41Z

0

You can use the Maatwebsite\Excel\Concerns\FromArray concern which works the same as FromCollection.

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;

class RegisteredMemberExport implements FromArray, WithHeadings
{
    public function array(): array
    {
        return [
            [
                'name' => 'Povilas',
                'email' => '[email protected]',
            ],
            [
                'name' => 'Taylor',
                'email' => '[email protected]',
            ],
        ];
    }

    public function headings(): array
    {
        return [
            'name',
            'email',
        ];
    }
}

Source

answered Jun 26, 2019 at 8:57

bmatovu

4,1341 gold badge41 silver badges41 bronze badges

Collectives™ on Stack Overflow

Laravel Maatwebsite excel array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related