Progress bar

[Ali8114]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1

What version of Laravel are you using?

5.8

What version of PHP are you using?

7.1

Describe your issue

While importing excel of data at approx 60,000, I need to show the progress bar in my blade view of laravel accordance with my importing of data.

How can the issue be reproduced?

I am importing my data using maatwebsite sharing you snippet for it,

row['entrydate'] = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row['entrydate'])->format('Y-m-d');
Client::create($row);

This is importing file code, time at which this button is triggered I am directly calling my route and function which redirect to my above code.

What should be the expected behaviour?

I want to show the progress bar as per my data is importing from excel for ex: data consist of 1,00,000 reocords or 1,000 records, That progress is need to be displayed in Blade View in Laravel.

[Paritosh2111]

I am also stuck with this and facing same issue while importing excel using maatwebsite need to show progress-bar in html as per my own data ( I have approx 5 Million records). NEED HELP

[Siddhesh220398]

When i was import the excel using maatwebsite progress bar in html is not working well using jquery code. I have 5-10 Million records Plz support me

[vishva13112000]

Same issue arise with me, I had still stuck with this, it will great if it has any solution.

[kunjalrc2038]

I'm facing same issue while importing... and also want to get number of imported rows from total number of rows from Excel during importing process.
[Output: (1/100)1%,....,(100/100)100%]

[eliasjtg]

Same issue, from 1 to 100% immediately

[dillingham]

Im guessing we have to import toArray and batch size it then queue our own jobs in batches and track the id via api polling

[dillingham]

maybe this can help

use RemembersRowNumber;

$currentRowNumber = $this->getRowNumber();