“”"
infos = [
{“name”:“zhangsan”,“age”:“18”, “gender”:“男”},
{“name”:“lisi”,“age”:“26”, “gender”:“女”},
{“name”:“wangwu”,“age”:“32”, “gender”:“男”}
]
“”"
import xlwt
class ExcelUtils():
“”"
写入 Excel文件
“”"
@staticmethod
def write2excel(infos, filename, sheetname="test"):
# 1. 创建 工作簿
work_book = xlwt.Workbook(encoding='utf-8')
# 2. 创建 表单
sheet = work_book.add_sheet(sheetname)
# 3. 写 表头,由于 keys 方法得到的是 迭代器,不能直接使用 len() 方法, 需要转为 列表。表头 写在 第一行,使用 字典的 键 为 每一列 属性名,
head = list(infos[0].keys()) # head: ["name","age","gender"]
for i in range(len(head)):
# write(行数,列数,内容)
sheet.write(0, i, head[i])
# 4. 写入内容,从第二行开始
rows = 1
# 获取 每一 列 数据
for j in range(len(head)):
sheet.write(rows,j, i[head[j]])
rows += 1
# 保存工作簿
work_hook.save(filename)
print("写入成功!")
infos = [{"name":"zhangsan","age":"18", "gender":"男"},
{"name":"lisi","age":"26", "gender":"女"},
{"name":"wangwu","age":"32", "gender":"男"}]
filename = "info_test"
ExcelUtils.write2excel(infos, filename)