Python 3.3 - 将字典粘贴到 Excel

Question

我想粘贴以下字典:

{'Olive Oil': 221.0, 'Ham - Pork': 216.14999999999998, 'Feta Cheese': 163.125, 'Vinegar': 5.1, 'Cherry Tomatoes': 22.5, 'Cucumber': 22.5}

在新的 Excel 工作簿中:

newbook = xlwt.Workbook(encoding="utf-8")
sheet = newbook.add_sheet('Table')

使用 xlwt

Answer 1

我用过类似的东西。希望这有帮助

import xlsxwriter

excelBook = xlsxwriter.Workbook('data.xlsx')
excelSheet = excelBook.add_worksheet()

elements = {'a':['e1','e2','e3'],
            'b':['e1','e2']
           } 
row = 0
col = 0

for key in elements.keys():
    row += 1
    excelSheet.write(row, col, key)
    for item in elements[key]:
        excelSheet.write(row, col + 1, item)
        row += 1

excelBook.close()

您还可以使用 DictWriter(在 csv 中)。