擅长:python、mysql、java
<p>下面是一种使用<a href="https://xlsxwriter.readthedocs.org/" rel="noreferrer">XlsxWriter</a>模块的方法:</p>
<pre><code>import xlsxwriter
workbook = xlsxwriter.Workbook('arrays.xlsx')
worksheet = workbook.add_worksheet()
array = [['a1', 'a2', 'a3'],
['a4', 'a5', 'a6'],
['a7', 'a8', 'a9'],
['a10', 'a11', 'a12', 'a13', 'a14']]
row = 0
for col, data in enumerate(array):
worksheet.write_column(row, col, data)
workbook.close()
</code></pre>
<p>输出:</p>
<p><a href="https://i.stack.imgur.com/oIvr3.png" rel="noreferrer"><img src="https://i.stack.imgur.com/oIvr3.png" alt="enter image description here"/></a></p>