Could you point the way on how to configure all the lines of a column by using PHPExcel with a numerical format?

Hi Experts

Could you point the way on how to configure all the lines of a column by using  PHPExcel with a numerical format?


This runs with a defined number of lines.

$objPHPExcel->getActiveSheet()->getStyle('AD2:....')->getNumberFormat()->setFormatCode('#,##0.00');

Select allOpen in new window

Column AD2

The number of lines of AD2 are unknown.

Thanks in advance