Laravel Excel: CSV to Array

Question

So I am working on a form where I want o give the user the option of uploading a CSV that will allow the form to be automatically populated. So I thought I would build a function that reads the CSV and then throws each row into an array as an object which I can then pass back to my Laravel Blade template. My only problem is, the array I return from the function is always empty. Any ideas?

private function import($path) {
    $applicants = [];

    Excel::load($path, function(LaravelExcelReader $excel) use ($applicants){
        $excel->each(function(Collection $line) use ($applicants){      
            $name = new \stdClass;    

            $name->first = $line->get('first');
            $name->middle = $line->get('middle');
            $name->last = $line->get('last');
            $name->birthdate = $line->get('birthdate');
            $name->ssn = $line->get('ssn');
            $name->email = $line->get('email');
            $name->mobile_phone = $line->get('mobile_phone');
            $name->home_phone = $line->get('home_phone');
            $name->street = $line->get('street');
            $name->city = $line->get('city');
            $name->state = $line->get('state');
            $name->zip = $line->get('zip');

            array_push($applicants, $name);
        });
    });    

    return $applicants;
}

Amit Gupta · Accepted Answer · 2016-12-15 16:50:15Z

1

Try it by using & operator in the use statement as:

Excel::load($path, function(LaravelExcelReader $excel) use (&$applicants){
   ...
}

OR

Make $applicants a class property then use it in your function as:

private function import($path) {
    $this->applicants = [];

    Excel::load($path, function(LaravelExcelReader $excel) {
        $excel->each(function(Collection $line) {      
            ...

            array_push($this->applicants, $name);
        });
    });    

    return $this->applicants;
}

answered Dec 15, 2016 at 16:50

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

Comments

Abhishek Sachan · Accepted Answer · 2016-12-15 17:25:29Z

1

Install - https://github.com/Maatwebsite/Laravel-Excel

And then Try below code:

$reader = \Excel::load($file_path);                  //this will load file
$results = $reader->noHeading()->get()->toArray();   //this will convert file to array
foreach($results as $v){
    \\process your array
}

answered Dec 15, 2016 at 17:25

Abhishek Sachan

2,3252 gold badges22 silver badges39 bronze badges

Comments

kiradotee · Accepted Answer · 2019-11-13 14:23:31Z

1

I had problems with using Laravel-Excel library for a very simple csv import, found a better solution using the FastExcel library.

First, install it via composer: composer require rap2hpoutre/fast-excel

And then you can simply use a one liner:

$arrayName = (new \Rap2hpoutre\FastExcel\FastExcel)->import('folder/file.csv')->toArray();

Otherwise:

use Rap2hpoutre\FastExcel\FastExcel;

$arrayName = (new FastExcel)->import('folder/file.csv')->toArray();

It's a quick and easy way to load a csv!

answered Nov 13, 2019 at 14:23

kiradotee

1,26514 silver badges21 bronze badges

Comments

mujuonly · Accepted Answer · 2020-01-22 07:50:25Z

1

Laravel 6 && Maatwebsite Excel3 Update:Jan 21 2020

$data = Excel::toArray(new \App\Imports\BaseImport(), $request->file('csv_file'));

Base import file

namespace App\Imports;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;

class BaseImport implements ToCollection {

    /**
     * @param Collection $collection
     */
    public function collection(Collection $rows) {
        return $rows;
    }

}

answered Jan 22, 2020 at 7:50

mujuonly

11.9k5 gold badges48 silver badges81 bronze badges

Comments

Jaykumar Patil · Accepted Answer · 2016-12-15 19:23:41Z

0

instead of

array_push($applicants, $name);

try this

$applicants[] = $name;

let me know if it works

answered Dec 15, 2016 at 19:23

Jaykumar Patil

3594 silver badges13 bronze badges

Comments

Kamal Soni · Accepted Answer · 2021-06-06 12:24:17Z

0

A slight refinement to @mujuonly answer, using an anonymous class.

use Maatwebsite\Excel\Concerns\ToCollection;

$array = Excel::toArray(new class implements ToCollection {
        public function collection(\Illuminate\Support\Collection $rows) {
            return $rows;
        }
    }, $csvFile
);

edited Jun 6, 2021 at 12:24

answered Jun 6, 2021 at 12:19

Kamal Soni

1,55215 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel Excel: CSV to Array

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related