擅长:python、mysql、java
<p>这里有几种方法可以给它打点</p>
<h2>环路</h2>
<p>将行初始化为0,并按每组数据的长度递增</p>
<p>因此,第一组数据将从第0行开始,然后下一组数据将位于该行下方,依此类推</p>
<pre><code>import xlsxwriter
all_list = [['aaa1','aaa2','aaa3'],
['bbb1','bbb2','bbb3'],
['ccc1','ccc2','ccc3']]
workbook = xlsxwriter.Workbook('qweqwe.xlsx')
worksheet = workbook.add_worksheet()
row = 0
for data in all_list:
worksheet.write_column(row, 0, data)
row += len(data)
</code></pre>
<h2>列表理解</h2>
<p>您还可以通过使用列表理解来“展平”列表</p>
<pre><code>import xlsxwriter
all_list = [['aaa1','aaa2','aaa3'],
['bbb1','bbb2','bbb3'],
['ccc1','ccc2','ccc3']]
workbook = xlsxwriter.Workbook('qweqwe.xlsx')
worksheet = workbook.add_worksheet()
data = [item for lst in all_list for item in lst]
worksheet.write_column(0, 0, data)
workbook.close()
</code></pre>