title: Read Excel with PHPExcel and insert array with MeekroDB
body: <p>I'm getting a list of columns from an Excel with PHPExcel, so far everything is fine, I can get the array and see the data on screen, even the columns that interest me and omitting the first rows, the problem is that I can not insert these array results in a database, I can not even insert the first record in the array. Can you help me? Thank you!</p>
  
  <pre><code>&lt;?php
  require_once 'connect.php';
  require_once 'Excel/PHPExcel/IOFactory.php';
  
  $objPHPExcel = PHPExcel_IOFactory::load('prices.xlsx');
  
  $worksheet = $objPHPExcel-&gt;getSheet(0);
  
  foreach($objPHPExcel-&gt;getWorksheetIterator() as $worksheet)
  {
      $highestRow = $worksheet-&gt;getHighestRow();
      $highestColumn = $worksheet-&gt;getHighestColumn();
  
      for($row=8; $row&lt;=$highestRow; $row++)
      {
          $column1 = $worksheet-&gt;getCellByColumnAndRow(5, $row)-&gt;getValue();
          $column2 = $worksheet-&gt;getCellByColumnAndRow(10, $row)-&gt;getValue();
          $column3 = $worksheet-&gt;getCellByColumnAndRow(11, $row)-&gt;getValue();
  
          $finaldata[] = array(
              'Key'           =&gt;      trim($column1),
              'Price'         =&gt;      trim($column2),
              'currency'      =&gt;      trim($column3),
          );
      }
  }
  
  echo "&lt;pre&gt;";
  print_r($finaldata);
  die();
  ?&gt;
  </code></pre>
  
  <p>I get the following:</p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
          (
              [Key] =&gt; 100001
              [Price] =&gt; 40.83
              [currency] =&gt; USD
          )
  
      [1] =&gt; Array
          (
              [Key] =&gt; 100002
              [Price] =&gt; 624.94
              [currency] =&gt; USD
          )
  
      [2] =&gt; Array
          (
              [Key] =&gt; 100003
              [Price] =&gt; 69.74
              [currency] =&gt; USD
          )
  
      [3] =&gt; Array
          (
              [Key] =&gt; 100004
              [Price] =&gt; 150.62
              [currency] =&gt; USD
          )
  
      [4] =&gt; Array
          (
              [Key] =&gt; 100005
              [Price] =&gt; 223.15
              [currency] =&gt; USD
          )
  
      [5] =&gt; Array
          (
              [Key] =&gt; 100006
              [Price] =&gt; 92.94
              [currency] =&gt; USD
          )
  )
  </code></pre>
  
  <p>Now I'm trying to insert all the records in my database with the following code:</p>
  
  <pre><code>&lt;?php
      DB::insert('prices', array(
          'Key' =&gt; $column1,
          'Price' =&gt; $column2,
          'currency' =&gt; $column3
      ));
  ?&gt;
  </code></pre>
  
  <p>I hope you can help me, thank you very much in advance for your time!</p>