WithMappedCells for a list of data

[joelharkes]

sometimes you really want to use WithMappedCells just to add some extra data to your row item, but using this instead makes Laravel-Excell think you just want to upload 1 item. Here is the workaround:

• remote WithMappedCells interface
• apply WithEvents and following code below:

    public function registerEvents(): array
    {
        return [
            BeforeSheet::class => function (BeforeSheet $event) {
                $data = [];
                foreach ($this->mapping() as $key => $value) {
                    $data[$key] = $event->sheet->getDelegate()->getCell($value)->getValue();
                }
                $this->extra = $data;
            }
        ];
    }

    public function toModel(array $data)
    {
        $fulldata = array_merge($this->extra, $data);
        // now use $full data as data-set including headers.
    }

gotcha's:

• This does only happen after validation, so validation rules wont work on these cells. to make that work: remove WithValidation and add following code yourself after array_merge:

 $fullValidatedData = app(Factory::class)->make($fulldata, $this->rules())->validate();