# coding:utf-8
import xlwt
students = [
{'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")
Python自动化(六)使用xlwt操作Excel
最新推荐文章于 2024-08-16 09:19:48 发布