title: phpexcel -How to change data type for whole column of an excel
body: <p>I'm trying to change the datatype for a whole column (for eg: i need to change for "M" Column to general format). Its displaying as <code>2.00</code> in quantity field,I need to change this whole column to general format ie. display as <code>"2"</code>. But its not changing the datatype.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>$objPHPExcel-&gt;getActiveSheet()
      -&gt;setCellValue(
          $aCells[$eExcelColumn] . $eExcelRow, 
          $sCellData , 
          PHPExcel_Cell_DataType::TYPE_NUMERIC
      );
  
  $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('M1:M97')
      -&gt;getNumberFormat()
      -&gt;setFormatCode('0');
  </code></pre>
  
  <p>How to do for the whole column "M" as general format</p>