[Bug]: Undefined array key

[agasigp]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1.32

What version of Laravel are you using?

8.40.0

What version of PHP are you using?

8.0.9

Describe your issue

I can't import data from xlsx file. It shows error undefined array key.

How can the issue be reproduced?

Here's my controller, import file class, the error message & excel file :

<?php

namespace App\Http\Controllers;

use App\Imports\CitizensImport;
use Illuminate\Http\Request;

class CitizenImportController extends Controller
{
      public function __invoke()
      {
          (new CitizensImport())->import(request()->file('file'));
      }
}

<?php

namespace App\Imports;

use App\Models\User;
use App\Models\Citizen;
use Maatwebsite\Excel\Row;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use Maatwebsite\Excel\Concerns\OnEachRow;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithUpserts;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithValidation;

class CitizensImport implements ToCollection, WithHeadingRow
{
    use Importable;

    public function collection(Collection $rows)
    {
        foreach ($rows as $row) {
            // dd($row['nama']);
            // $data = $row->toArray();
            // dd($data);
            $user = User::create([
                'puskesmas_id' => 1,
                'name' => $row['nama'],
                'email' => $row['email'],
                'phone_number' => $row['no_telepon'],
                'password' => bcrypt($row['email']),
            ]);

            $citizen = new Citizen();
            $citizen->fill([
                'nik' => $row['nik'],
                'name' => $row['nama'],
                'sex' => $row['jk_mf'],
                'birth_date' => $row['tanggal_lahir_yyyy_mm_dd'],
                'street_address' => $row['alamat_jalankompleks'],
                'rt' => $row['rt'],
                'rw' => $row['rw'],
                'phone_number' => $row['no_telepon'],
                'email' => $row['email'],
                'village_id' => $row['desa_id'],
                'puskesmas_id' => $row['puskesmas_id'],
                'user_id' => $user->id,
            ]);
            $citizen->user_id = $user->id;
            $user->save();
        }
    }

    public function uniqueBy()
    {
        return 'nik';
    }
}

What should be the expected behaviour?

The data on the excel file should be inserted into database.

[patrickbrouwers]

You have to add checks yourself to see if the array key exists or not. Use dd($row) or dump($row) to debug your implementation.

[agasigp]

I just did that. Here's the result of dd($rows) & dd($row) :

[agasigp]

[PROBLEM SOLVED]

It's my mistake. My excel file has two sheets, so it tried to access the second sheet after the first sheet is done. I just need the data from first sheet. I just changed my code to just read the data from first sheet only. Thank you for help & response for this.

[depamelina]

how to change the code to read data just from only first sheet? :'