擅长:python、mysql、java
<p>有很多方法可以写入Excel文件,但是当您使用xlsxwriter时;让我为你使用同样的方法</p>
<p><strong>您可以尝试以下代码:</strong></p>
<pre><code>import xlsxwriter
letters = ['A', 'B', 'C']
data = [{'Theme':'Operating environment','Sub-Theme': 'Regional Demand','Quote':'In China Cash flow from operating activities was $670 million, up 19%.ABB\'s regional and country order trends for the third quarter are illustrated on Slide 4.'},{'Theme':'Competitive advantage','Sub-Theme': 'None','Quote':'Specifically, in the United States, our largest market, Electrification order growth was robust apart from large orders, which had a tough comparison base.'}]
FileName="Output.xlsx"
workbook = xlsxwriter.Workbook(FileName)
worksheet = workbook.add_worksheet()
bold = workbook.add_format({'bold': True})
header_col_name=['Theme','Sub-Theme','Quote']
for i in header_col_name:
worksheet.write(''+letters[header_col_name.index(i)]+'1', i, bold)
i=2
for d in data:
for j in header_col_name:
worksheet.write(''+letters[header_col_name.index(j)]+ str(i), d[j])
i=i+1
workbook.close()
</code></pre>