PHPExcel: Setting font size?

Question

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.

score 85 · Accepted Answer · edited Jul 11 '19 at 15:16

85

Use setSize method instead setFontSize, it should work:

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

edited Jul 11 '19 at 15:16

simhumileco

answered Jan 09 '13 at 18:08

vvolkov

simhumileco · Answer 2 · 2019-09-13T21:34:48.290

9

If you want to use the style array, then you can do something like this:

$fontStyle = [
    'font' => [
        'size' => 16
    ]
];

$workbook->getActiveSheet()
    ->getStyle("F1:G1")
    ->applyFromArray($fontStyle);

edited Sep 13 '19 at 21:34

answered Feb 21 '17 at 13:03

simhumileco

score 0 · Answer 3 · answered Jul 13 '23 at 09:49

You can using setSize or applyFromArray to setting font size, like code below:

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

OR

$objPHPExcel->getActiveSheet()->getStyle("F1:G1")->applyFromArray(array(
    "font"  => array(
        "size"  => 16
    )
));

3 Answers3