phpclassphpexcel

Set Font Color, Font Face and Font Size in PHPExcel


I'm working in PHPExcel. I'm beginner.When I'm using following code and its working fine.

$phpExcel = new PHPExcel();

$phpExcel->getActiveSheet()->getStyle("A1")->getFont()->setBold(true)
                                ->setName('Verdana')
                                ->setSize(10)
                                ->getColor()->setRGB('6F6F6F');

But when I'm using following code and not getting expected result as above.

$phpFont = new PHPExcel_Style_Font();
$phpFont->setBold(true);
$phpFont->setName('Verdana');
$phpFont->setSize(15);

$phpColor = new PHPExcel_Style_Color();
$phpColor->setRGB('FF0000');  

$phpExcel->getActiveSheet()->getStyle('A1')->setFont( $phpFont );
$phpExcel->getActiveSheet()->getStyle('A1')->getFont()->setColor( $phpColor );

Please help me what am I doing wrong in above code.

Thank you in advance!


Solution

  • I recommend you start reading the documentation (4.6.18. Formatting cells). When applying a lot of formatting it's better to use applyFromArray() According to the documentation this method is also suppose to be faster when you're setting many style properties. There's an annex where you can find all the possible keys for this function.

    This will work for you:

    $phpExcel = new PHPExcel();
    
    $styleArray = array(
        'font'  => array(
            'bold'  => true,
            'color' => array('rgb' => 'FF0000'),
            'size'  => 15,
            'name'  => 'Verdana'
        ));
    
    $phpExcel->getActiveSheet()->getCell('A1')->setValue('Some text');
    $phpExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    

    To apply font style to complete excel document:

     $styleArray = array(
       'font'  => array(
            'bold'  => true,
            'color' => array('rgb' => 'FF0000'),
            'size'  => 15,
            'name'  => 'Verdana'
        ));      
     $phpExcel->getDefaultStyle()
        ->applyFromArray($styleArray);