Delete empty row - openpyxl
<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>