Laravel export excel from array return empty file

Question

I want to download excel file from array with Laravel

Library:

use Maatwebsite\Excel\Facades\Excel;

This is my code:

$ex = [
    ['one', 'name'],
    ['two', 'family']
];

return Excel::download(new TestExport([$ex]), 'test.xlsx');

My class:

class TestExport
{
    protected $arrays;

    public function __construct(array $arrays)
    {
        $this->arrays = $arrays;
    }

    public function array(): array
    {
        return $this->arrays;
    }
}

But this code download empty xlsx file

@aimme I edited my question. I use Maatwebsite\Excel\Facades\Excel; — Rez Mohsnei
– Rez Mohsnei, Commented Dec 5, 2021 at 13:45

Rez Mohsnei · Accepted Answer · 2021-12-05 13:52:32Z

2

I found answer:

class TestExport implements FromCollection, WithHeadings
{
    protected $data;
  
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function __construct($data)
    {
        $this->data = $data;
    }
  
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function collection()
    {
        return collect($this->data);
    }
  
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function headings() :array
    {
        return [
            'ID',
            'Name',
            'Email',
        ];
    }
}

Source: https://www.itsolutionstuff.com/post/laravel-create-csv-file-from-custom-array-using-maatwebsiteexample.html

answered Dec 5, 2021 at 13:52

Rez Mohsnei

2071 gold badge6 silver badges18 bronze badges

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

1 Comment

aimme Over a year ago

so mark it as correct answer. welcome to stackoverflow :)

Ali Azimi · Accepted Answer · 2021-12-05 14:19:51Z

2

I appreciate your research to find the answer yourself. Agreeing with your own answer, I also want to emphasize that the Excel library that you are using, accepts Laravel collection, not an array. So, you need to convert your array to a collection using the 'collect' helper function as bellow:

$myCollection = collect($this->ar);

Then export it using Excel facade:

return Excel::download(new TestExport($myCollection), 'test.xlsx');

answered Dec 5, 2021 at 14:19

Ali Azimi

4144 silver badges18 bronze badges

Collectives™ on Stack Overflow

Laravel export excel from array return empty file

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related