我有一本包含 2000 个项目的字典,如下所示:
d = {'10071353': (0, 0), '06030011': (6, 0), '06030016': (2, 10), ...}
鉴于我想将其写入.xlsx
文件,我使用这段代码(取自here https://stackoverflow.com/questions/23113231/python-write-dictionary-values-in-an-excel-file?answertab=active#tab-top):
import xlsxwriter
workbook = xlsxwriter.Workbook('myfile.xlsx')
worksheet = workbook.add_worksheet()
row = 0
col = 0
order=sorted(d.keys())
for key in order:
row += 1
worksheet.write(row, col, key)
for item in d[key]:
worksheet.write(row, col + 1, item)
row += 1
workbook.close()
这会产生一个.xlsx
文件具有以下对齐方式:
A B
06030001 0
10
06030002 10
10
06030003 5
10
然而,这就是我所追求的对齐方式:
A B C
06030001 0 10
06030002 10 10
06030003 5 10
我应该在脚本中更改什么才能实现此目的?
我认为这应该有所帮助:
import xlsxwriter
workbook = xlsxwriter.Workbook('myfile.xlsx')
worksheet = workbook.add_worksheet()
row = 0
col = 0
order=sorted(d.keys())
for key in order:
row += 1
worksheet.write(row, col, key)
i =1
for item in d[key]:
worksheet.write(row, col + i, item)
i += 1
workbook.close()
IN:
d={'10071353':(0, 0),'06030011':(6, 0),'06030016':(2, 10)
OUT:
A B C
06030001 6 0
06030002 2 10
06030003 0 0
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)