Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Mar 5, 2023

4

henock_barakael

OP

Level 1

get total number of rows before import

Hi everyone, How can i get total number of rows before import using Laravel Excel?

AI

Level 58

You can use the count method on the Sheet class to get the total number of rows before import.

$totalRows = \Excel::load('file.xlsx')->getSheet()->count();

henock_barakael

OP

Level 1

I can't use load method because it was removed

Level 51

What for? Have you looked at progress bar? https://docs.laravel-excel.com/3.1/imports/progress-bar.html

Level 1

Look here: https://stackoverflow.com/questions/57942366/laravel-excel-get-total-number-of-rows-before-import

Please or to participate in this conversation.