Undefined index when using WithHeadingRow

[MrBean14]

Hello,

I'm encountering the error "Undefined index" for all my column names.
I tried all I could find online but it does not work.

My Import

<?php

namespace App\Imports;

use App\Car;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class CarsImport implements ToModel, WithHeadingRow
{
    public function model(array $row)
    {
        return new Car([
            'license'   => $row['Nummerplaat'], 
            'code'      => $row['chassisnummer'], 
            'brand'     => $row['merk'], 
            'type'      => $row['model'], 
        ]);
    }
}

My Controller function

    public function import(Request $request){
        if ($request->hasFile('car_file')) {
            Excel::import(new CarsImport, $request->file('car_file'));
        }
        
        return redirect()->route('cars.home');
    }

The header of my excel file:

The error message

What could I be doing wrong please?

Thanks,

Davy

[patrickbrouwers]

Try and dd($row) and see what the actual keys are. Probably it's lower case nummerplaat as the headings are slugged

[patrickbrouwers]

You have to use the WithMultipleSheets concern: https://docs.laravel-excel.com/3.1/imports/multiple-sheets.html

If you only want to handle the first sheet, you can use and use the import itself as sheet import. If not, make 2 import classes for each sheet.

public function sheets(): array
    {
        return [
            $this
        ];
    }

[MrBean14]

Thanks Patrick,

I changed the code in the controller to this

Should I add something in the Import too?

Because now it says

[patrickbrouwers]

If you need onlySheets make sure to following the documentation and use the trait: https://docs.laravel-excel.com/3.1/imports/multiple-sheets.html#conditional-sheet-loading

[MrBean14]

Patrick, I would like to thank you for all the help.
All is working like expected now.

[patrickbrouwers]

You're welcome happy to hear!