title: Delete empty row - openpyxl
body: <p>After spending the last few hours trying to find a way to do this, I've decided to just ask.</p>
  
  <p>I've gone through the <a href="https://openpyxl.readthedocs.org/en/2.5/" rel="noreferrer">openpyxl docs</a> more than a few times, as well as going through the questions asked <a href="https://stackoverflow.com/questions/31475811/how-to-check-if-a-cell-is-empty-in-openpyxl-python">here</a> and <a href="https://stackoverflow.com/questions/12311345/manipulating-excel-2007-files-using-python/12325130#12325130">here</a>, and even the chapter from <a href="https://automatetheboringstuff.com/chapter12/" rel="noreferrer">this online book</a>, and none of it really answers what I'm attempting to do.</p>
  
  <p>Here's the code I have right now:</p>
  
  <pre><code>for row in ws.iter_rows():
      i = 1
      if row[i].internal_value() == None:
          ws.Rows(i).Delete()
      else:
          i + 1
  </code></pre>
  
  <p>I've tried many different things with this, and right now I'm getting an error:</p>
  
  <blockquote>
    <p>TypeError: 'NoneType' object is not callable</p>
  </blockquote>
  
  <p>What am I doing wrong, and how can I fix it so that I'm iterating over all of the rows and deleting any that either are completely empty, or (if it's easier to implement) have an empty first cell?</p>
  
  <p>Thanks</p>