python excel 多行合并一行

Question

求学习代码，谢谢大神！！！！

Answer 1

#-*- 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')