Convert excel to array in Laravel

Question

I'm using matlab excel plugin for convert excel to array. My code is:-

public static function ImportExcel($table="", $path=""){
    $data = array();
    Excel::load($path, function ($reader) use($data) {
        $data = $reader->toArray();
        //here data has all excel data in array.
    });
    return $data; //but here it shows empty array.
}

Check my comments in code. Inside the Excel::load data has array of all data. But its scope is only inside the Excel::load. I need it outside.

score 2 · Accepted Answer · answered Oct 17 '18 at 06:54

The load has an internal function, thus the variables are enclosed inside that function and it also cannot access variables from outside this function, unless they are passed to the function with the use statement. In other words, $data inside the function does not reference to the $data outside it. In order to fix this you will have to add $data to the use statement like this:

public static function ImportExcel($table="", $path=""){
    $data = array();
    Excel::load($path, function ($reader) use($table, $data) {
        $data = $reader->toArray();
        //here data has all excel data in array.
    });
    return $data; //but here it shows empty array.
}

No, Still it returns empty array. – Sahil Gupta Oct 17 '18 at 06:57 — Sahil Gupta, Oct 17 '18 at 06:57

Jignesh Joisar · Answer 2 · 2018-10-17T07:02:56.783

2

try this way

$data = Excel::load($path, function ($reader) use($table) {
        $data = $reader->toArray();
        //here data has all excel data in array.
});

otherwise create array before and after clousers

$array = [];
Excel::load($path, function ($reader) use($table, $array) {
    $array = $reader->toArray();
    //here data has all excel data in array.
});

third way doing like that

$results = Excel::load($path);
$data = $results->toArray();

edited Oct 17 '18 at 07:02

answered Oct 17 '18 at 06:58

Jignesh Joisar

13,720
5
57
57

@SahilGupta try third way – Jignesh Joisar Oct 17 '18 at 07:03
Version 3 doesn't have the load method https://stackoverflow.com/a/49473174/2543240 – Positivity Oct 04 '19 at 20:00

score 2 · Answer 3 · edited Jul 20 '20 at 16:29

I write an answer with more detail for another persons who wants to use Maatwebsite\Excel :

if ($request->hasFile('imported_file')){
    $updateFile = $request->file('imported_file');
    
    $path = $updateFile->getRealPath();
    $fileExtension = $updateFile->getClientOriginalExtension();
    
    $formats = ['xls', 'xlsx', 'ods', 'csv'];
    if (! in_array($fileExtension, $formats)) {
        return back()->with("status", 'The uploaded file format is not allowed.');
    }
    
    $data = Excel::load($path, function ($reader) {}, 'UTF-8')->get();
    
    if (! empty($data) && $data->count()) {
        $data = $data->toArray();
        foreach ($data as $perData) {
            // Do whatever you like on per data in your imported data
        }
    }
}

Convert excel to array in Laravel

3 Answers3