phpphpexcel

PHPExcel: Setting font size?

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.

Solution

  • Use setSize method instead setFontSize, it should work:

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