擅长:python、mysql、java
<p>jmcnamara的解决方案很有效。我发布了一个类似的可能的解决方案,但动态的。在</p>
<pre><code>import xlsxwriter
workbook = xlsxwriter.Workbook("<your path>")
worksheet = workbook.add_worksheet()
# add style for first column
cell_format = workbook.add_format({'bold': True})
text_wrap = workbook.add_format({'text_wrap': True, 'valign': 'top'})
data = []
description_combined = 'firstline: abc \n secondline: bcd \n thirdline: efg'
# prepare list of list
for item in description_combined.split("\n"):
data.append(cell_format)
data.append(item.split(":")[0].strip() + ":")
data.append(item.split(":")[1] + "\n")
# write data in one single cell
data.append(text_wrap)
worksheet.write_rich_string('A1', *data)
workbook.close()
</code></pre>
<p>我希望这会有帮助</p>