title: Get cell style with phpExcel from ods file
body: <p>I'm using the PHPExcel lib to read spread sheets. With xlsx and xls files it works fine, but not with ods and ots.</p>
  
  <p>I'm trying to get the background color of the cell but with ods files I always get <code>FFFFF</code> instead of the actual cell color.</p>
  
  <p>Here is the code I'm working on:</p>
  
  <pre><code>$cantCOL = 5;
  try {
      //file route
      $rutaArchivo = $_FILES["archivo"]["tmp_name"];
      //phpExcel Reader
      $objReader = PHPExcel_IOFactory::createReaderForFile($rutaArchivo);
      //ReadDataOnly false, to get cell color
      $objReader-&gt;setReadDataOnly(false);
      //load spreedsheet from file route
      $objLibro = $objReader-&gt;load($rutaArchivo);
      //set the active sheet
      $objLibro-&gt;setActiveSheetIndex(0);
      //get last row number
      $n = $objHoja-&gt;getHighestRow();
      //Loop through the rows
      for ($fila = 1; $fila &lt;= $n; $fila++) {
          //Loop through the columns
          for($col = 0; $col &lt; $cantCOL+2; $col++){
              $columnLetter = PHPExcel_Cell::stringFromColumnIndex($col);
              //get the cell color, RGB format
              $cellColor = $objLibro-&gt;getActiveSheet()-&gt;getStyle($columnLetter.$fila)
                                -&gt;getFill()
                                -&gt;getStartColor()
                                -&gt;getRGB();
               if($cellColor!='000000' &amp;&amp; $cellColor!='FFFFFF' &amp;&amp; !$error){
                   //Show cell color
                   echo '&lt;script language="javascript"&gt;alert("Color: "'.$cellColor.'");&lt;/script&gt;';
               }else{
                   echo '&lt;script language="javascript"&gt;alert("No Color");&lt;/script&gt;';
               }
           }
       }
   } catch (Exception $e) {
       echo '&lt;script language="javascript"&gt;alert("Error:"'.$e.'");&lt;/script&gt;';
   }
  </code></pre>