Laravel Excel ErrorException Undefined offset: 0

Question

Trying to import excel data to my mysql db and getting ErrorException Undefined offset: 0.

Tried using var_dump($row) to check the array of the row of the data. It looks off and not sure how to make the data shows nicely so that able to pass to db.

array(5) { ["a"]=> string(1) "B" ["white"]=> string(5) "Green" ["example1_at_gmailcom"]=> string(18) "[email protected]" [60123456789]=> int(60162313142) [5]=> int(5) }

This is my excel data:

Model

 public function model(array $row)
{
    var_dump($row);
    return new ContactList([
        'first_name' => $row[0],
        'last_name' => $row[1],
        'email' => $row[2],
        'phone' => $row[3],
        'group_id' => $row[4],
    ]);
}

I already tried using replacing the $row[] with string and it works perfectly storing the data into my db.

Controller

if($request->hasFile('selected_file')){

            $file = $request->file('selected_file');
            Excel::import(new ContactListsImport, $file);


            return redirect()->back()->with('success', 'Data saved successfully!');
        }

you are dumping the array you are getting ... do you see a key 0 in it? — lagbox
– lagbox, Commented Oct 10, 2020 at 8:45
sry, i am new to this. No i didnt see it but even i removed the vardump i still getting the same error ErrorException Undefined offset: 0 — N.Tec
– N.Tec, Commented Oct 10, 2020 at 8:47
because there is no index 0 as you can see as you dumped the array and there is no key 0 ... you can't access keys of an array that don't exist ... you have an issue here as the first row of this file is being used as the headers (column names), you should look into the documentation to adjust this or not use this behavior — lagbox
– lagbox, Commented Oct 10, 2020 at 8:48
Just an FYI, but Laravel using Symfony's VarDumper component so you can use dump() and dd() for a more readable output. — Rwd
– Rwd, Commented Oct 10, 2020 at 8:49

Rwd · Accepted Answer · 2020-10-10 09:05:42Z

1

You need to remove the WithHeadingRow interface from your Import class to use numeric indexes for the array.

As per the documentation, when your Import class implements WithHeadingRow it will use the first row for the indexes of the array and in turn remove it from the rows that are provided.

answered Oct 10, 2020 at 9:05

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

2 Comments

N.Tec Over a year ago

Yes, I think this is the reason why

Rwd Over a year ago

@N.Tec If this has answered your question please may you mark it as accepted :)

Collectives™ on Stack Overflow

Laravel Excel ErrorException Undefined offset: 0

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related