PHP函数计算Excel工作表没有包含数据的行

Question

I am using PHPExcel where following line of command gives full data Range.

echo $objPHPExcel->getActiveSheet()->calculateWorksheetDataDimension()

Outputs:

A1:XFD153

But i need only the number of rows, i.e 153 for above case.

Is there any inbuilt function to get number of excel rows which has data ?

Answer 1

I think you want...

echo $objPHPExcel->getActiveSheet()->getHighestRow();