SyntaxFix

[php] Set Font Color, Font Face and Font Size in PHPExcel

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);

Examples related to php

• I am receiving warning in Facebook Application using PHP SDK • Pass PDO prepared statement to variables • Parse error: syntax error, unexpected [ • Preg_match backtrack error • Removing "http://" from a string • How do I hide the PHP explode delimiter from submitted form results? • Problems with installation of Google App Engine SDK for php in OS X • Laravel 4 with Sentry 2 add user to a group on Registration • php & mysql query not echoing in html with tags? • How do I show a message in the foreach loop?

Examples related to class

• String method cannot be found in a main class method • Class constructor type in typescript? • ReactJS - Call One Component Method From Another Component • How do I declare a model class in my Angular 2 component using TypeScript? • When to use Interface and Model in TypeScript / Angular • Swift Error: Editor placeholder in source file • Declaring static constants in ES6 classes? • Creating a static class with no instances • In R, dealing with Error: ggplot2 doesn't know how to deal with data of class numeric • Static vs class functions/variables in Swift classes?

Examples related to phpexcel

• How to center the text in PHPExcel merged cell • PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically • PHPExcel set border and format for all sheets in spreadsheet • Set Font Color, Font Face and Font Size in PHPExcel • PHPExcel - set cell type before writing a value in it • PHPExcel auto size column width • PHPExcel Make first row bold • How to export data to an excel file using PHPExcel • PHP Excel Header • PHPExcel - creating multiple sheets by iteration