title: PHPExcel: How to get all column A in an array?
body: <p>I have this code that I'm using to get all column A as a PHP array: </p>
  
  <pre><code>&lt;?php 
  
  include 'Classes\PHPExcel\IOFactory.php';
  
  $objPHPExcel = PHPExcel_IOFactory::load('keywords.xlsx');
  
  $allDataInSheet = $objPHPExcel-&gt;getActiveSheet()-&gt;toArray(null,true,true,true);
  
  $arrayCount = count($allDataInSheet);  // Here get total count of row in that Excel sheet
  
      for( $i=2; $i&lt;=$arrayCount; $i++ )
      {
          $value1 = trim($allDataInSheet[$i]["A"]);       
          var_dump($value1);
      }
  
  ?&gt;
  </code></pre>
  
  <p>It works on one Excel file that has a list of numbers on column A: </p>
  
  <p>Example of an output: </p>
  
  <pre><code>string '111111' (length=6)
  string '222222' (length=6)
  string '333333' (length=6)
  string '444444' (length=6)
  string '555555' (length=6)
  </code></pre>
  
  <p>But when I have a list of texts: </p>
  
  <p><a href="https://i.stack.imgur.com/K0pO9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K0pO9.png" alt="enter image description here"></a></p>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>( ! ) Warning: array_keys() expects parameter 1 to be array, integer given in C:\wamp\www\PHPExcel\Classes\PHPExcel\Calculation.php on line 3079</p>
  </blockquote>
  
  <p>Any idea why this is happening? </p>