Python自动化（六）使用xlwt操作Excel

# coding:utf-8import xlwtstudents = [    {'name': "孙淑悦", 'qq': "8882222"},    {'name': "吕婉源", 'qq': "8882222"},    {'name': "孔德源", 'qq': "8882222"}]f = xlwt.Workbook(encoding='utf-8')sheet = f.add_sheet('student')for row, student in enumerate(students):    for col, key in enumerate(sorted([key for key in student])):        sheet.write(row, col, student[key])f.save("students.xls")