擅长:python、mysql、java
<blockquote>
<p>Why the excel data not starting from (0,0) cell.</p>
</blockquote>
<p>因为工作表类的<a href="http://nullege.com/codes/search/openpyxl.worksheet.Worksheet.append" rel="nofollow noreferrer">the ^{<cd1>} method</a>:</p>
<blockquote>
<p>Appends a group of values at the bottom of the current sheet.</p>
</blockquote>
<p>换句话说,这个方法找到下一个可用/空行,并将数据转储到那里,这是有意义的。您还希望<code>append</code>方法如何工作?<code>list.append</code>不写入项0,它将一个新成员添加到列表</em>。与<code>worksheet.append</code>方法的想法相同。在</p>
<p>要先清除现有单元格,请尝试:</p>
<p><a href="https://stackoverflow.com/questions/36582460/how-to-clear-a-range-of-values-in-an-excel-workbook-using-openpyxl">How to clear a range of values in an Excel workbook using OpenPyXl</a></p>