Maatwebsite/Excel Exporting Error

Question

I am using Laravel 5.4 and I want to export a record to a excel file but I got this error

Argument 1 passed to Illuminate\Database\Eloquent\Builder::create() must be of the type array, string given, called in C:\xampp\htdocs\www\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php on line 1332 and defined

and here is my code:

   $export = Student::all();
    Excel::create('Export Excel',function($excel) use($export){
        $excel->sheet('Sheet 1', function($sheet) use($export){
            $sheet->fromArray($export);

        });
    })->download('xlsx');

   $export = Student::all();
Excel::create('Export Excel',function($excel) use($export){
    $excel->sheet('Sheet 1', function($sheet) use($export){
        $sheet->fromArray($export);

    });
})->download('xlsx');

What is the content of your code at line 1332?

plmrlnsnts
– plmrlnsnts

2018-05-14 09:17:00 +00:00
Commented May 14, 2018 at 9:17 — plmrlnsnts
– plmrlnsnts, Commented May 14, 2018 at 9:17

Björn · Accepted Answer · 2018-05-14 09:40:51Z

1

$export is an Eloquent collection and you are using the fromArray method so it expects an array.

You can do two things:

Convert your Eloquent collection to an array:

$sheet->fromArray($export->toArray());

Use the fromModel method that accepts an Eloquent collection:

$sheet->fromModel($export);

answered May 14, 2018 at 9:40

Björn

5,9061 gold badge28 silver badges35 bronze badges

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

Comments

JCPHPDev · Accepted Answer · 2018-05-14 09:57:31Z

0

Perhaps you have a model named "Excel" that makes the problem.

Just make an alias for "Maatwebsite/Excel" when you imported :

use Maatwebsite\Excel\Facades\Excel as MaatExcel;

answered May 14, 2018 at 9:57

JCPHPDev

1695 bronze badges

Collectives™ on Stack Overflow

Maatwebsite/Excel Exporting Error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related