Python自动办公实例-excel处理实例（多工作表合并到单工作表.zip

import openpyxl wb=openpyxl.load_workbook('各年业绩表.xlsx') nwb=openpyxl.Workbook() nws=nwb.active nws.append(['年份','月份','金额']) for ws in wb.worksheets: l=[[ws.title]+[c.value for c in row] for row in ws.rows][1:-1] for v in l: nws.append(v) nwb.save('合并1.xlsx')