title: PhpSpreadsheet - get row without iterating on each cell
body: <p>I'm using PhpSpreadsheet to easily read from a xls document and insert into a DB after some calculations. I succeeded using examples from the documentation, but I find it sooo complicated I'm sure I missed something and it can be done much more easily.</p>
  
  <pre><code>$worksheet = $this-&gt;getWorksheet("file.xls");
  foreach ($worksheet-&gt;getRowIterator() as $row) {
    $cellIterator = $row-&gt;getCellIterator();
    $cellIterator-&gt;setIterateOnlyExistingCells(FALSE);
    foreach ($cellIterator as $key =&gt; $cell) {
      $cellValue = $cell-&gt;getValue();
  
      if($key == 'A')
        $field1 = $cellValue;
      if($key == 'B') {
        $dateTime = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($cellValue);
        $date = $dateTime-&gt;format("Y-m-d");
      }
      if($key == 'C')
        $field2 = $cellValue;
      if($key == 'D')
        $field3 = $cellValue;
      if($key == 'E')
        $field4 = $cellValue;
    }
  }
  </code></pre>
  
  <p>I would have expected something like <code>$row-&gt;getCell("A")-&gt;getValue()</code> to be available. </p>
  
  <p>So... Have I missed something ?</p>