擅长:python、mysql、java
<p>您可以简单地将所有python字典添加到一个列表中,这样就可以为每个学生迭代这些字典,以填充每一行的每一列。像这样:</p>
<p><strong>更新以解决运营商的意见</strong></p>
<p>对于#1,只需在第一行写入标题,然后将其他行偏移一行即可</p>
<p>对于#2,如果id不在字典中,您可以简单地利用<a href="https://docs.python.org/2/library/stdtypes.html#dict.get" rel="nofollow">^{<cd1>}</a>而不是{<cd2>}符号来分配默认值:</p>
<pre><code>import xlsxwriter
workbook = xlsxwriter.Workbook('student_data.xlsx')
worksheet = workbook.add_worksheet()
bold = workbook.add_format({'bold': 1})
students = student_id.keys()
fields = [student_age, student_id] # add other dicts here...
headers = ['name', 'age', 'id'] # ...
# write out a header row
for i, header in enumerate(headers):
worksheet.write(0, i, header, bold)
for row, student in enumerate(student):
row = row + 1
worksheet.write(row, 0, student) # name column
for col, student_data in enumerate(fields):
col = col + 1
worksheet.write(row, col, student_data.get(student, ''))
</code></pre>