openpyxl 写入字典
def write(self,data_path, sheetname,value):
index = len(value)
workbook = openpyxl.Workbook()
sheet = workbook.active
sheet.title = sheetname
for i in range(0, index):
for j in range(0, len(value[i])):
sheet.cell(row=i + 1, column=j + 1, value=str(value[i][j]))
workbook.save(data_path)
print("xlsx格式表格写入数据成功!")