How to stop chunk read process based on current chunk data

[abin12914]

I am using withBatchInserts, withChunkReading and ToModel contracts to import spreadsheets to the database. There is an issue with some files when importing. The Maatwebsite\Excel\Jobs\ReadChunk process doesn't stop when data is finished. It continues the process until manually stopped. I noticed that only some files have this issue, especially, .xlsx files.

Is there any way to stop the process and return success to the chained jobs when a chunk of data is empty?

In my test file only 234 rows are present. batchSize is 10 and chunkSize is 100. But as seen in the below image, the process runs unlimited times.

[patrickbrouwers]

Try the skips empty rows concern

[abin12914]

Hi @patrickbrouwers , Thank you for the reply.

I am already using the Maatwebsite\Excel\Concerns\SkipsEmptyRows concern and it doesn't help.

One thing I noticed is when there is a huge number of empty rows in the file, the jobs table experiences some issues.

[patrickbrouwers]

Maybe https://github.com/SpartnerNL/Laravel-Excel/blob/3.1/config/excel.php#L101