Pyton实操多个Excel数据合并在同一个Excel的不同sheet

from openpyxl import load_workbook, Workbook
from os import listdir


def copy_data():
    path='E:/Python/Poject1'
    wb = Workbook()
    sh = wb.active
    for name in listdir(path):
        Path = f'{path}/{name}'
        temp_wb = load_workbook(Path )
        temp_sh = temp_wb.active
        sh_new = wb.create_sheet(name.split('.')[0])
        # sh_new = wb[name]  不需要多此一举
        for r in range(1, temp_sh.max_row+1):
            row = []
            for c in range(1, temp_sh.max_column):
                row.append(temp_sh.cell(r, c).value)
            sh_new.append(row)
    del wb['Sheet']
    wb.save('处理后.xlsx')


copy_data()