[QUESTION] How to skip empty row among other rows when import?

[simontruongduc]

first of all thank you so much for this Library. Working great .
I want to remove all empty rows before validation. I edited ignore_empty in config/excel.php to true value but it only removes empty rows from the last row set value but empty row among other rows have value hasn't been removed yet.
Ex:

when i imported this file it was returned 4 collection.
{
"code"=>1,
"email"=>"test@gmail.com",
"username"=>"usernameA"
},
{
"code"=>NULL,
"email"=>NULL,
"username"=>NULL
},
{
"code"=>1,
"email"=>"test@gmail.com",
"username"=>"usernameA"
},
{
"code"=>1,
"email"=>"test@gmail.com",
"username"=>"usernameA"
}

I want to delete the 2nd collection before it does validation. please help me.

[patrickbrouwers]

Did you try SkipsEmptyRows ?

[simontruongduc]

Thank you but I didn't find it in document. I am using version 3.1

[patrickbrouwers]

Seems it didn't deploy properly, you can find it here for now: https://github.com/Maatwebsite/laravel-excel-docs/pull/137/files

[patrickbrouwers]

https://docs.laravel-excel.com/3.1/imports/validation.html#skipping-empty-rows

[simontruongduc]

thank you . I will try it