擅长:python、mysql、java
<p>您可以指定单元格索引:</p>
<pre><code>import xlsxwriter
workbook = xlsxwriter.Workbook('write_data.xlsx')
worksheet = workbook.add_worksheet()
worksheet.write(0, 0, 1234) # Writes an int
worksheet.write(1, 0, 1234.56) # Writes a float
worksheet.write(2, 0, 'Hello') # Writes a string
worksheet.write(3, 0, None) # Writes None
worksheet.write(4, 0, True) # Writes a bool
workbook.close()
</code></pre>
<p>在您的情况下,您可以使用<code>join</code>和<code>add_format</code>:</p>
<pre><code>import xlsxwriter
workbook = xlsxwriter.Workbook('write_data.xlsx')
worksheet = workbook.add_worksheet()
wrap_format = workbook.add_format({'text_wrap': True})
lst = [['aaa1','aaa2','aaa3'],['bbb1','bbb2','bbb3']]
worksheet.write(0, 0, '\n'.join(lst[0]), wrap_format)
worksheet.write(1, 0, '\n'.join(lst[1]), wrap_format)
workbook.close()
</code></pre>
<p><a href="https://i.stack.imgur.com/IU4pV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IU4pV.png" alt="Output"/></a></p>