- '''将数据写入 excel'''
- def write_excel(self, file_path, sheet_name, date_dict: dict):
- """
- :param file_path: excle 文件的绝对路径
- :param sheet_name: 将数据写入哪一页
- :param date_dict: 写入的数据, 字典类型
- :return:
- """
- wb = load_workbook(file_path) # file_path:excle 文件的路径
- sheet = wb[sheet_name]
- # 写入列名
- j = 0
- for key in date_dict[list(date_dict.keys())[0]]:
- j += 1
- sheet.cell(row=1, column=j).value = key
- # 写入各列值
- i = 1
- for key_i in date_dict.keys():
- i += 1
- j = 0
- for key_j in date_dict[key_i]:
- j += 1
- sheet.cell(row=i, column=j).value = date_dict[key_i][key_j]
- wb.save(file_path) # 保存文件
来源: http://www.bubuko.com/infodetail-3217547.html