title: PHPExcel class wrong value for column
body: <p>I am using PHPExcel class to read the xls file and then trying to insert into the db. But when I displayed the highest index value of row and column, it shows an error result for column field. I have data up to index 'R', but the code shows $highestColumn=J and $highestColumnIndex=10. But the highest row index is correct. My code is given below:</p>
  
  <pre><code>&lt;?php
  $filename="test.xls";
  require_once '../Classes/PHPExcel/IOFactory.php';
  if (!file_exists($filename))
  {
      echo "Not Exist!";
  }
  $objPHPExcel = PHPExcel_IOFactory::load($filename);
  foreach ($objPHPExcel-&gt;getWorksheetIterator() as $worksheet)
  {
      $worksheetTitle     = $worksheet-&gt;getTitle();
      $highestRow         = $worksheet-&gt;getHighestRow(); // e.g. 10
      $highestColumn      = $worksheet-&gt;getHighestDataColumn(); // e.g 'F'
      $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
      $nrColumns = ord($highestColumn) - 64;
      echo $highestColumn;
      echo "&lt;br/&gt;";
      echo $highestColumnIndex;
  
  ?&gt;
  </code></pre>
  
  <p>My xls file column index format is given below:</p>
  
  <p><img src="https://i.stack.imgur.com/LfYlR.png" alt="image of excel column index">
  Any Idea?</p>