擅长:python、mysql、java
<p>此替代方法通过计算可能跳过值的行(如文档中的特殊标题部分)以及对第一列<em>N</em>进行采样来解决接受答案的问题:</p>
<pre class="lang-py prettyprint-override"><code>def next_available_row(sheet, cols_to_sample=2):
# looks for empty row based on values appearing in 1st N columns
cols = sheet.range(1, 1, sheet.row_count, cols_to_sample)
return max([cell.row for cell in cols if cell.value]) + 1
</code></pre>