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

Question

I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error

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

My controller

public function importsave(Request $request)
{
   if($request->hasFile('excel'))
    {
        $path = $request->file('excel')->getRealPath();
        $data= Excel::load($path, function($reader) {})->get();
        if(!empty($data) && $data->count())
        {
            foreach($data->toArray() as $key=>$value)
            {
                if(!empty($value))
                {
                    Employee::insert($value);
                }
            }
        }
    }
}

score 34 · Accepted Answer · edited Oct 22 '21 at 21:09

34

Version 3.0 of that package doesn't handle imports yet. Release date for this feature is unknown. See this post for more details: https://medium.com/@maatwebsite/laravel-excel-lessons-learned-7fee2812551

I suggest you switch to version 2.*.

Else you want to continue further ALL Laravel Excel 2.* methods are deprecated and will not be able to use in 3.0 .

   Excel::load() is removed and replaced by Excel::import($yourImport)
    Excel::create() is removed and replaced by Excel::download/Excel::store($yourExport)
    Excel::create()->string('xlsx') is removed an replaced by Excel::raw($yourExport, Excel::XLSX)

3.0 provides no convenience methods for styling, you are encouraged to use PhpSpreadsheets native methods.

edited Oct 22 '21 at 21:09

Ronny Dsouza

358
2
12

answered Mar 25 '18 at 06:34

jedrzej.kurylo

39,591
9
98
107

@RioAditya could you mark the question as answered? – jedrzej.kurylo Mar 25 '18 at 16:06
1

Version 3.1 is now available with import functionality https://docs.laravel-excel.com/3.1/imports – Dan May 14 '20 at 12:21
1

My whole project is in laravel 6.18 and now I can't install maatwebsite/excel 2.1 or any closer version, please help – Swarnadeep Oct 11 '20 at 17:07
@Swarnadeep did you installed maatwebsite/excel 2.1 and checked? – Uma Mar 03 '21 at 11:42

score 12 · Answer 2 · edited May 16 '19 at 06:35

12

Hi there in version 3 the load method was remove so switch back to version two like so try using this command,

composer require "maatwebsite/excel:~2.1.0"

edited May 16 '19 at 06:35

Keyur

1,113
1
23
42

answered Aug 02 '18 at 06:26

Dawood Iddris

121
1
4

1

its actually "maatwebsite/excel":"~2.1.0" – Cengkuru Michael Jan 28 '19 at 14:00
Gives an error "- Conclusion: remove laravel/framework v5.8.18" So it might not be compatible with new versions. – Kusal Dissanayake Jun 27 '19 at 17:35
I have v2.1 maatwebsite/excel and 5.8 laravel do I need to downgrade my laravel version? \ – Pablo Nov 22 '19 at 02:15

score 12 · Answer 3 · answered Jul 27 '19 at 10:19

12

ALL Laravel Excel 2.* methods are deprecated and will not be able to use in 3.0 .

Excel::load() is removed and replaced by Excel::import($yourImport)
Excel::create() is removed and replaced by Excel::download/Excel::store($yourExport)
Excel::create()->string('xlsx') is removed an replaced by Excel::raw($yourExport, Excel::XLSX)

3.0 provides no convenience methods for styling, you are encouraged to use PhpSpreadsheets native methods.

answered Jul 27 '19 at 10:19

Engr Syed Rowshan Ali

746
6
16

this cpuld be the marked answer – Ronny Dsouza Oct 21 '21 at 12:37

score 10 · Answer 4 · answered Dec 01 '21 at 10:30

10

Dont panic :) Just do like this

Excel::toArray([],$filePath);

Just pass an empty array as the first parameter

answered Dec 01 '21 at 10:30

konik

173
1
2
8

works like a charm on package version 3.1 (PHP 8.1, Laravel 9) – habib Aug 01 '22 at 09:42

score 9 · Answer 5 · edited Jan 25 '20 at 07:15

9

^3.0 versions of maatwebsite/excel does not support loads.
Delete the config/excel.php file first .

Downgrade the maatwebsite/excel version by changing your composer.json file from "maatwebsite/excel": "^3.1", to "maatwebsite/excel": "~2.1.0", and performing 'composer update'.

And if you get an error:

Undefined class constant 'XLSX' in 2.1 version

this is what you have to do.
Delete the config/excel.php before downgrading then perform the composer update.

edited Jan 25 '20 at 07:15

MartenCatcher

2,713
8
26
39

answered Jan 25 '20 at 05:21

Aravind

191
2
10

Doesnt work for laravel 6, its dependency doesnt match – Akbar Noto Mar 30 '20 at 02:08

score 3 · Answer 6 · answered Sep 24 '18 at 15:46

Version 3.0 of Laravel Excel doesn't handle imports.

You could also use an alternative package that works with import such as:

https://github.com/Cyber-Duck/laravel-excel (Laravel Excel Fork)
https://github.com/rap2hpoutre/fast-excel (Faster alternative to Laravel Excel)

Both handles import.

You could also switch to version 2, but it means use an old version of a lib.

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

6 Answers6

Linked