title: Openpyxl How to get row from worksheet by index
body: <p>Using Openpyxl and python3.5, I tried getting the first row from an excel worksheet using a subscript but I an error. </p>
  
  <pre><code># after getting filename
  # after loading worksheet
  # to get the first row of the worksheet
  first_row = worksheet.rows[0]
  
  # I get 
  Traceback (most recent call last):
        File "&lt;pyshell#54&gt;", line 1, in &lt;module&gt;
        first_row = phc_th_sheet.rows[1]
  TypeError: 'generator' object is not subscriptable
  </code></pre>
  
  <p>In relation to getting the first row, I've also tried 
       first_row = worksheet.(row=1)
       # and
       first_row = worksheet.rows[:1]</p>
  
  <p>None worked. Any suggestions or is the feature not available in openpyxl?
  I've been to the documentation at <a href="https://openpyxl.readthedocs.io/en/default/" rel="noreferrer">https://openpyxl.readthedocs.io/en/default/</a> but I found nothing helpful enough to index and select rows</p>