Update docs to include nested mapped import (SpartnerNL#214)

biber · web-flow · commit cf3802fcbaea · 2023-11-29T10:43:41.000+01:00
diff --git a/4.x/imports/mapped-cells.md b/4.x/imports/mapped-cells.md
@@ -21,7 +21,7 @@ use App\User;
 use Maatwebsite\Excel\Concerns\ToModel;
 use Maatwebsite\Excel\Concerns\WithMappedCells;
 
-class UsersImport implements WithMappedCells, ToModel 
+class UsersImport implements WithMappedCells, ToModel
 {
     public function mapping(): array
     {
@@ -30,7 +30,7 @@ class UsersImport implements WithMappedCells, ToModel
             'email' => 'B2',
         ];
     }
-    
+
     public function model(array $row)
     {
         return new User([
@@ -44,3 +44,43 @@ class UsersImport implements WithMappedCells, ToModel
 ::: warning
 This concern is not meant to map **columns**, only specific **cell** reference are allowed.
 :::
+
+## Multi-demensional Mapping
+
+In case you have repeating data in your table, e. g. a spreadsheet looking like this:
+
+| Team 1 | | Team 2| |
+|-|-|-|-|
+| Max | 2 | Peter | 3 |
+| Annie | 0 | Alex | 1 |
+
+you are also able to define cell coordinates in a nested array:
+
+```php
+public function mapping(): array
+{
+    return [
+        'team1' => [
+            [
+                'name' => 'A2',
+                'score' => 'B2',
+            ],
+            [
+                'name' => 'A3',
+                'score' => 'B3',
+            ],
+        ],
+        'team2' => [
+            [
+                'name' => 'C2',
+                'score' => 'D2',
+            ],
+            [
+                'name' => 'C3',
+                'score' => 'D3',
+            ],
+        ],
+    ];
+}```
+
+Note that an array of the same form will be returned.
