python - 如何以正确的列对齐方式将字典转储到 .xlsx 文件中？

Question

我有一本包含 2000 个条目的字典，如下所示:

d = {'10071353': (0, 0), '06030011': (6, 0), '06030016': (2, 10), ...}

考虑到我想将它写入 .xlsx 文件，我使用此代码(取自 here ):

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

我应该在脚本中更改什么以实现此目的？

Answer 1

这是我认为应该有所帮助的:

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