How to get count of all sheets from imported excel file ?

[vishalinfyom]

Hello,

i want to import data from excel sheet number 9 to 15.

Know how to get count of all sheets count from imported excel file ?

[patrickbrouwers]

I would highly recommend reading the architecture docs to get an understanding how import objects work. We have an example of counting rows in there: https://docs.laravel-excel.com/3.1/architecture/objects.html#getters Same concept applies to sheets.

[vishalinfyom]

Hii @patrickbrouwers i think you are not able to get me I want total sheets to count not rows count of the specific sheet.

is this possible?

Thanks in advance.

[patrickbrouwers]

You could use phpspreadsheet directly to use getSheetCount

[scottfell]

This is what I came up with after finding it on the phpspreadsheet https://phpspreadsheet.readthedocs.io/en/latest/topics/reading-files/

$path = storage_path('myworkbook.xlsx');
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load($path);
$sheetCount = $spreadsheet->getSheetCount();