Import large excel file using package fast-excel with validation

[hasanhadi]

Hi how can using package fast-excel for import large excel file more 100K rows with validation if you have code for more information Thanks

[Franckevarice]

hello here, I have the same problem. need help please

[otsabi94]

same problem

[StefanoTesla]

I think, you need to import and validate by yourself, Laravel Excel have this feature but ram usage is different.

In my case FastExcel use 20Mb of ram, Laravel Excel used 176mb...

[sektonic]

use this

$users = (new FastExcel)->import('file.xlsx', function ($line) {
    Validator::make($line, [
        'Email' => 'required',
        'Name' => 'required',
        'Password' => 'required',
    ]);

    return User::create([
        'email' => $line['Email'],
        'name' => $line['Name'],
        'password' => Hash::make($line['Password'])
    ]);
});