Laravel-excel: Validating All Sheets on Import

[archy-bold]

Prerequisites

• [x] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [x] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [x] Checked that your question isn't already asked before.
• [x] Filled in the entire issue template

Versions

• PHP version: 7.1.28
• Laravel version: 5.6.39
• Package version: 3.1.13

Description

I've got an import class which has multiple sheets; I'm performing validation within the array() function manually. If there are any validation issues with the first sheet, it just throws the ValidationException and so I can only see issues with the first sheet. Is there anything I can do to continue onto the next sheet even if the first fails?

[GlennM]

public function collection(Collection $rows)
    {
         try {
Validator::make($rows->toArray(), [
             '*.0' => 'required',
         ])->validate();
} catch(ValidationException $e)
{
    // store validation errors somewhere and get them at the end of the validation via a getter
}

        foreach ($rows as $row) {
            User::create([
                'name' => $row[0],
            ]);
        }
    }

(extended version of https://docs.laravel-excel.com/3.1/imports/validation.html#row-validation-without-tomodel; handle the try-catch yourself)

[archy-bold]

Good idea, will give that a go.