字典到xlwt的列表 [英] List of Dictionary to xlwt

问题描述

我有一个词典的列表，我想使用 xlwt 将其转换为excel.我是xlwt的新手.你能帮助我吗?我使用它作为接收字典列表并将其转换为excel然后返回的函数.我有这份字典清单.

I have a list of dictionary and i want to convert it to excel using xlwt. I'm new to xlwt. Can you help me? Im using it as a function to receive list of dict and convert it to excel and then return. I have this list of dict.

{'id':u'1','name':u'Jeff'}

 {'id':u'2','name':'Carlo'}

推荐答案

制作工作表.然后使用 Worksheet.write 填充一个单元格.

Make a worksheet. Then use Worksheet.write to fill a cell.

data = [
    {'id':u'1','name':u'Jeff'},
    {'id':u'2','name':'Carlo'},
]

import xlwt

w = xlwt.Workbook()
ws = w.add_sheet('sheet1')

columns = list(data[0].keys()) # list() is not need in Python 2.x
for i, row in enumerate(data):
    for j, col in enumerate(columns):
        ws.write(i, j, row[col])

w.save('data.xls')

这篇关于字典到xlwt的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！