PHPSpreadsheet: how to get the number of loaded rows?

Question

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();

score 57 · Accepted Answer · answered Feb 14 '18 at 16:50

57

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

answered Feb 14 '18 at 16:50

Mark Baker

209,507
32
346
385

4

to be noted: for columns, they have a similarly but not very intuitively named method `getHighestColumn` – YakovL Nov 09 '18 at 09:21
1

this gives column index e.g AJ what about count? – Nixon Kosgei Nov 25 '20 at 10:53
1

@NixonKosgei - then use the Coordinate columnIndexFromString() method to convert AJ to its numeric equivalent – Mark Baker Nov 30 '20 at 13:08

PHPSpreadsheet: how to get the number of loaded rows?

1 Answers1