擅长:python、mysql、java
<p>也许您应该考虑使用一个额外的类<code>ExcelWorksheet</code>,以便将与它们相关的所有逻辑放入其中:</p>
<pre><code>class ExcelWorksheet(object):
def __init__(self, workbook, name):
self.wb = workbook
self.ws = self.wb.add_worksheet(name)
self.wsLineCount = 0
def write_data(self, data, title):
self.ws.write_row(self.wsLineCount, 0, title)
self.wsLineCount += 1
self.ws.write_row(self.wsLineCount, 0, data)
self.wsLineCount += 1
</code></pre>
<p>这样,您可以将代码重构为:</p>
^{pr2}$