title: How to get XLS file format value using PHPExcel
body: <p>I have XLS cells deference number formatted. this how look like my cells</p>
  
  <p><img src="https://i.stack.imgur.com/jVqZg.png" alt="Cells of the XLS file"></p>
  
  <ul>
  <li>E8: Date formatted cell</li>
  <li>E9: Number formatted cell</li>
  <li>E10: General formatted cell</li>
  <li>E11: Percentage formatted cell</li>
  <li>E12: Fraction formatted cell</li>
  </ul>
  
  <p>I want to read these above cells data without any changes(Friday, May 10, 2013 , 41404.00, drfsdf, 1/2) i use below method for that but i didn't success every bellow method return for text value of the cells</p>
  
  <pre><code>$objReader = new PHPExcel_Reader_Excel5();
  $objReader-&gt;setReadDataOnly(true);
  $objPHPExcel = $objReader-&gt;load($file_path);
  $rowIterator = $objPHPExcel-&gt;getActiveSheet()-&gt;getRowIterator();
  
  $array_data = array();
  foreach ($rowIterator as $row) {
     $cellIterator = $row-&gt;getCellIterator();
     $cellIterator-&gt;setIterateOnlyExistingCells(false);
     $rowIndex = $row-&gt;getRowIndex();
     $array_data[$rowIndex] = array('A' =&gt; '', 'B' =&gt; '');
     foreach ($cellIterator as $cell) {
      if ('A' == $cell-&gt;getColumn()) {
           $array_data[$rowIndex][$cell-&gt;getColumn()] = $cell-&gt;getCalculatedValue();
        } else if ('B' == $cell-&gt;getColumn()) {
           $array_data[$rowIndex][$cell-&gt;getColumn()] = $cell-&gt;getCalculatedValue();
        }
     }
  }  
  </code></pre>
  
  <p>please help to get view value of the XLS file as <code>Friday, May 10, 2013 , 41404.00, drfsdf, 1/2</code> in to the $array_data  using PHPExcel.</p>