PHPExcel: Setting font size

PHPphpexcel

I have been looking to change the font size of some Excel cells using a PHP library called PHPExcel.

This is what I tried:

$objPHPExcel->getActiveSheet()->getStyle("F1:G1")->getFont()->setFontSize(16);

The method above does not work. I was wondering if anyone knows how to do this?

Many thanks in advance.

Best Answer

Use setSize method instead setFontSize, it should work:

$objPHPExcel->getActiveSheet()->getStyle("F1:G1")->getFont()->setSize(16);
Related Topic