Import excel file to database using Laravel

Question

why get undefined offset when importing excel file to the database using laravel.

UserImport.php

public function model(array $row)
{
    var_dump($row);
    
    return new User([
        'name' =>$row[0],
        'email'=>$row[1],
        'password' => Hash::make('password'),

    ]);
}

UserImportController

public function store(Request $request){

    $file = $request->file('file');
    Excel::import(new UsersImport, $file);
    return back()->withStatus('Successfully');
}

when uploading the excel file, display it like this. enter image description here

I used var_dump() to see the array. I entered 4 rows in the excel file. But display 5 array data. Why that??? (display in entered image. )

Aleksandar Milivojsa · Accepted Answer · 2021-03-26 13:31:50Z

0

I believe it is because of the new line at the end of the file.

You should check if it contains only a new line and skip the import.

answered Mar 26, 2021 at 13:31

Aleksandar Milivojsa

3953 silver badges13 bronze badges

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

1 Comment

R.W.S. Maleesha Over a year ago

I added if condition to UserImport.php if($row[0] !=""){ return new User([ 'name' =>$row[0], 'email'=>$row[1], 'password' => Hash::make('password'), ]); }

R.W.S. Maleesha · Accepted Answer · 2021-03-26 14:02:13Z

0

set if condition for UserImport.php

if($row[0] !=""){ 
    return new User([ 
        'name' =>$row[0], 
        'email'=>$row[1], 
        'password' => Hash::make('password'), 
   ]); 
}

answered Mar 26, 2021 at 14:02

R.W.S. Maleesha

72 bronze badges

Collectives™ on Stack Overflow

Import excel file to database using Laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related