# Mapped Cells
In case you have a more custom spreadsheet and only want to access specific cells, you can implement the WithMappedCells
concern.
You might have a speadsheet looking like this:
name | Patrick Brouwers |
---|---|
patrick@maatwebsite.nl |
We can now map name
to B1
and email
to B2
. The value of those coordinates will then be available under the given array key.
namespace App\Imports;
use App\User;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithMappedCells;
class UsersImport implements WithMappedCells, ToModel
{
public function mapping(): array
{
return [
'name' => 'B1',
'email' => 'B2',
];
}
public function model(array $row)
{
return new User([
'name' => $row['name'],
'email' => $row['email'],
]);
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
This concern is not meant to map columns, only specific cell reference are allowed.