How to fix Call to undefined method Maatwebsite\Excel\Excel::create()?

Question

My program produces this error but I don't know why:

Call to undefined method Maatwebsite\Excel\Excel::create()

Code:

public function exportExcel(){
    $users = User::all();
    $user_array = array('Name', "Email");
    foreach($users as $user){
        $user_array[] = array(
            'Name' => $user->name,
            'Email' => $user->email,
        );

    }
    Excel::create('User Data', function ($excel) use ($user_array){
        $excel->setTitle('User Data');
        $excel->sheet('User Data', function($sheet) use ($user_array){
         $sheet->fromArray($user_array);
        });
       })->download('xls');
    return redirect()->route('admin.page');
}

Which version of Laravel Excel you have used?

Udhav Sarvaiya
– Udhav Sarvaiya

2018-12-15 14:52:49 +00:00
Commented Dec 15, 2018 at 14:52 — Udhav Sarvaiya
– Udhav Sarvaiya, Commented Dec 15, 2018 at 14:52
It is version 3.1.4

Jo Jo
– Jo Jo

2018-12-15 15:14:39 +00:00
Commented Dec 15, 2018 at 15:14 — Jo Jo
– Jo Jo, Commented Dec 15, 2018 at 15:14

Saman Ahmadi · Accepted Answer · 2018-12-16 17:59:06Z

1

According to this docs (Officinal document Here):

You may do this by using the make:export command.

php artisan make:export UsersExport --model=User

If you prefer to create the export manually, you can create the following in App/Exports:

<?php

namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

In your controller you can call this export now:

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;

class UsersController extends Controller 
{
    public function export() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
}

Find your users.xlsx in your downloads folder!

edited Dec 16, 2018 at 17:59

answered Dec 15, 2018 at 14:34

Saman Ahmadi

6873 silver badges9 bronze badges

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

3 Comments

Saman Ahmadi Over a year ago

which version of Excel library r u using? u can find it in your composer.json file

Jo Jo Over a year ago

3.1.4 version is what I am using

Subhra Jyoti Lahiri Over a year ago

I know this question might not stand, but can't we make excel from custom arrays. I mean to say, if they are not models. Created based on some calculations?

Jignesh Joisar · Accepted Answer · 2018-12-15 14:28:53Z

1

try this one

you are using Maatwebsite\Excel\Excel class instead of use import facade Excel

use Maatwebsite\Excel\Facades\Excel;

other wise used

use Excel;

answered Dec 15, 2018 at 14:28

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

Comments

Udhav Sarvaiya · Accepted Answer · 2018-12-15 15:20:52Z

0

Add the ServiceProvider in config/app.php

'providers' => [
    Maatwebsite\Excel\ExcelServiceProvider::class,
]

Add the Facade in config/app.php

'aliases' => [
    ...
    'Excel' => Maatwebsite\Excel\Facades\Excel::class,
]

Laravel Excel can be used in a various of ways.

Usage:

use Maatwebsite\Excel\Excel;

answered Dec 15, 2018 at 15:20

Udhav Sarvaiya

10.2k13 gold badges60 silver badges68 bronze badges

2 Comments

Udhav Sarvaiya Over a year ago

ALL Laravel Excel 2.* methods are deprecated and will not be able to use in 3.0 . Excel::create() is removed and replaced by Excel::download/Excel::store($yourExport)

Jo Jo Over a year ago

When I try to use store or download it says that I am using them statically, what does this mean?

Collectives™ on Stack Overflow

How to fix Call to undefined method Maatwebsite\Excel\Excel::create()?

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related