title: PHPExcel: Coloring the cells?
body: <p>I'm using the PHPExcel to generate some sheets on my server. More or less it everything works fine, but, when I try to color some rows (every second row, so the list would be easily readable) I get funny thing: the row is colored ok, but only on cells that are not filled with data. The cells that are filled with data remain white.</p>
  
  <p>Here's code I use</p>
  
  <pre><code>            $ind = ($ind + 1) % 2;
  
              if($ind == 1)
              {
                  $style_header = array(                  
                  'fill' =&gt; array(
                      'type' =&gt; PHPExcel_Style_Fill::FILL_SOLID,
                      'color' =&gt; array('rgb'=&gt;'CCC'),
                  ),
                  'font' =&gt; array(
                      'bold' =&gt; true,
                  )
                  );
                  $sheet-&gt;getStyle($row)-&gt;applyFromArray( $style_header );
  
              }
  
              $sheet-&gt;getCellByColumnAndRow(0, $row)-&gt;setValue($item['qty']);
              $sheet-&gt;getCellByColumnAndRow(1, $row)-&gt;setValueExplicit($item['name']);
              $sheet-&gt;getCellByColumnAndRow(2, $row)-&gt;setValueExplicit($item['size']);
              $sheet-&gt;getCellByColumnAndRow(3, $row)-&gt;setValueExplicit($item['color']);
  </code></pre>
  
  <p>What am I doing wrong?</p>