求学习代码,谢谢大神!!!!
6条回答 默认 最新
- 天际的海浪 2020-12-24 19:22关注
#-*- coding:utf-8 -*- import openpyxl book = openpyxl.load_workbook(r'输入文件.xlsx') sh = book.active head = [x.value for x in sh[1]] body = {} index = None for r in sh.iter_rows(min_row=2): i = r[0].value arr = body.setdefault(i,[i]) for v in r[1:]: arr.append(v.value) arr = list(body.values()) n = (len(arr[0])-1)//(len(head)-1) head = head[0:1] + head[1:] * n newbook = openpyxl.Workbook() sh = newbook.active sh.append(head) for t in arr: sh.append(t) newbook.save(r'输出文件.xlsx')
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报