title: Phpexcel - how to set the font format of a cell value
body: <p>I am using phpexcel library. but when I want to set the font color, and different style for a cell value then when I export my file then those changes not applied there.
  my code is below </p>
  
  <pre><code>&lt;?php 
      require_once (SPEE_PLUGIN_DIRS . "/Classes/PHPExcel.php");
  
      require_once (SPEE_PLUGIN_DIRS . "/Classes/PHPExcel/IOFactory.php");
  
      $objPHPExcel = new PHPExcel();
  
      $styleArray = array(
                         'font'  =&gt; array(
                         'bold'  =&gt; true,
                         'color' =&gt; array('rgb' =&gt; 'FF0000'),
                         'size'  =&gt; 15,
                         'name'  =&gt; 'Verdana'
                         ));                                       
  
      $objPHPExcel-&gt;setActiveSheetIndex(0);
  
      $objPHPExcel-&gt;setActiveSheetIndex(0)-&gt;mergeCells('A1:H1');
  
      $objPHPExcel-&gt;setActiveSheetIndex(0)-&gt;mergeCells('A2:H2');
  
      $objPHPExcel-&gt;setActiveSheetIndex(0)-&gt;mergeCells('A3:H3');
  
      $objPHPExcel-&gt;setActiveSheetIndex()-&gt;getStyle('E1')-&gt;applyFromArray(array("font" =&gt; array( "bold" =&gt; true))); // font not set bold.
  
      $objPHPExcel-&gt;getActiveSheet()-&gt;setCellValue('E1', 'my data');
  
      $objPHPExcel-&gt;getActiveSheet()-&gt;getCell('A7')-&gt;setValue('CNIC No');  
  
      $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A7')-&gt;applyFromArray($styleArray); // this style array not work on 'A7'
  
  ?&gt;
  </code></pre>