PHPSpreadsheet: how to get the number of loaded rows?

php excel phpspreadsheet
Pontiac_CZ picture Pontiac_CZ · Feb 14, 2018 · Viewed 20.5k times · Source

How do I find out how many rows I have loaded using PHPSpreadsheet\Reader\Xlsx::load() method?

I cannot find methods (or properties) for getting row count in Spreadsheet or Worksheet classes either.

BTW I am using following code:

$filename = 'test.xlsx';
$inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($filename);
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);

$reader->setReadDataOnly(true);  
$reader->setLoadSheetsOnly($sheet);  

$this->spreadsheet = $reader->load($filename);
$this->worksheet = $this->spreadsheet->getActiveSheet();

Answer

Mark Baker picture Mark Baker · Feb 14, 2018

Using the worksheet's getHighestRow() method 

$highestRow = $this->spreadsheet->getActiveSheet()->getHighestRow();

or getHighestDataRow() if you're only interested in rows where cells contain data and not any blank rows at the end of the worksheet

Related questions

Composer require phpoffice/phpspreadsheet doesn't work

I want to write a Script using the package Phpspreadsheet. I am not experience in php. I am trying to add the reference to my script through sudo composer require phpoffice/phpspreadsheet. But it doesn't work. I am getting the …

Read More
Write data from array to sheet using phpspreadsheet library

How can I create excel sheet column headers from array using phpspreadsheet library? Below is the code I am trying but it's not working: // $header is an array containing column headers $header = array("Customer Number", "Customer Name", "Address", "City", "State", "…

Read More
Building very large spreadsheet with PHPSpreadsheet

I'm testing out how PHPSpreadsheet works with large excel spreadsheets. Initial tests indicate that for a large spreadsheet one will quickly run out of memory. Is there a way to write the spreadsheet progressively? I have an old piece of …

Read More