title: Reading numbers as text format with PHPExcel
body: <p>I have an array that can store numbers in such as 01, 01A, 01B, 02, 2, and When I get this value using PHPExcel, it's being removed the '0's in case of 01, 02, for example. To solve this problem, I tried to format the row where these values will be stored in excel and set it as text type, just like in the following code:</p>
  
  <pre><code>    $objPHPExcel-&gt;setActiveSheetIndexByName('BlocksList');
      $objPHPExcel-&gt;getActiveSheet()-&gt;fromArray($blockNames, null, 'A2');
      $latestBLColumn = $objPHPExcel-&gt;getActiveSheet()-&gt;getHighestDataColumn();
      $column = 'A';
      $row = 1;
      for ($column = 'A'; $column != $latestBLColumn; $column++) {
          $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle($column.$row)-&gt;getNumberFormat()-&gt;setFormatCode( PHPExcel_Style_NumberFormat::FORMAT_TEXT );
      }
      $objPHPExcel-&gt;getActiveSheet()-&gt;fromArray($blockNames, null, 'A1');
  </code></pre>
  
  <p>So, by doing this, I get the array with numbers like 01, 01A, 02, 02B... and I store it in the Row A2. I get the highest Column to use this value in the condition For. In this condition, I set for the Row 1 in the range A until the highest column, to be formated as text. </p>
  
  <p>My template is generated, and all the numbers are in text format, but the problem is that I think when I use the "<code>fromArray()</code>" method, it transforms the numbers of the array before I can get it right in excel.
  Do you have any idea of how can I solve this problem??</p>