Import: Specific cells mapping not working

[markp131]

I am trying to get the value of some cells in a sheet from an excel file. According to the docs (https://docs.laravel-excel.com/3.1/imports/mapped-cells.html) I need to use WithMappedCells and their example code is:

public function mapping(): array
    {
        return [
            'name'  => 'B1',
            'email' => 'B2',
        ];
    }
    
    public function model(array $row)
    {
        return new User([
            'name' => $row['name'],
            'email' => $row['email'],
        ]);
    }

Here is my spreadsheet:

In my import file I have this mapping

public function mapping(): array
    {
        return [
            'type_key'  => 'A1',
            'isDraft_key' => 'A2',
            'isPublished_key' => 'A3',
            'type'  => 'B1',
            'isDraft' => 'B2',
            'isPublished' => 'B3',
            
        ];
    }

On their github I found this solution: #1836 (comment)

public function map($row)
    {
        return new Veiling([
            'name' => $row['name'],
            'nummer' => $row['nummer'],
            'info' => $row['info'],
        ]);
    }

However, this still tried to add it to a Model. I noticed that it used $row So I tried is this:

public function map($row): array {
        Log::info($row['type_key']);
        return $row;
    }

But I get this error:

Undefined index: type_key

How do I simple get those values from those specific cells so I can perform some checks on them?

Edit: When I log out just $row I get:

array (
  0 =>
  array (
    'type' => 'isDraft',
    'report.' => 'TRUE',
  ),
  0 =>
  array (
    'type' => 'isPublished',
    'report.' => 'FALSE',
  ),
)

As you can see, the data is there but the mapping is not correct. I have checked and I am using :

use Maatwebsite\Excel\Concerns\WithMappedCells;
use Maatwebsite\Excel\Concerns\WithMapping;

at the top of my file and am making sure my class implements these:

Import Implements WithMapping, WithMappedCells {

[patrickbrouwers]

Perhaps have a look at this unit test we have: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/tests/Concerns/WithMappedCellsTest.php#L64

Perhaps it will help you find a solution

[markp131]

Hello. Thank you for the reply. The response you gave is the same as the docs is it not? Am I being really stupid here?

[patrickbrouwers]

It most likely is the same example yes. However you can also check the Excel file we use. Perhaps there's some difference in approach.

[markp131]

I think it is the same example. I also cant find the "mapped-import.xlsx" file in the repository as mentioned in the code.

[patrickbrouwers]

https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/tests/Data/Disks/Local/mapped-import.xlsx

If you are able to provide a failing unit test with your use-case, that would be helpful

[dreammonkey]

Sorry to bump in on this, but could it be that the WithMapping concern cannot be used in combination with the WithMappedCells concern ?

I think It actually makes sense if this is indeed the case. I did however stumble on a similar issue where I need to map one row's value to a 'hard coded' cell location in combination with dynamic mappings (and WithHeadingRow).

I think this is a very specific edge case scenario, that is indeed not covered in the test cased you referenced.

The csv could look like this:

username	John Doe
ID	NAME
1	item1
2	item2

I will try to write a (failing) test.
But I was also wondering if there could another way to reference the static cell in the map callback ?

public function map($row): array
{
  return [
    'username' => someMethodToResolve('B1'),
    'id' => $row['ID'],
    'name' => $row['NAME'],
  ];
}

Highest regards,
Diederik