Laravel-excel: How to count rows of imported excel?

[simplenotezy]

I wish to count the rows of the imported excel. Currently I do something like this:

 $imported = count(\Excel::load($file->getPathName(), function($reader) {})->get());

[ghost]

I am having the same issue. I would like help on this as well please. Thank You

[dannyweeks]

You could use the count method on the Collection

$rows = \Excel::load($file->getPathName(), function($reader) {})->get();

$totalRows = $rows->count();

[patrickbrouwers]

@dannyweeks' answer is correct

[coderdiaz]

Thanks for this solution @dannyweeks

[geradt]

How do you prevent laravelexcel from counting empty rows that have borders or some other styling component?

[shaikhqaseem769]

$reader->ignoreEmpty();

[zawnaingtun-mbridge]

@patrickbrouwers
Check how many rows in imported excel file. (version 3.1)

[patrickbrouwers]

There is an example in the docs in the architecture chapter

[RizwanNawaz01]

$rows = \Excel::load($file->getPathName(), function($reader) {})->get();

$totalRows = $rows->count();

The Load is removed is there any other way to count the rows
@dannyweeks

[RizwanNawaz01]

Follow this
https://docs.laravel-excel.com/3.1/architecture/objects.html#getters