python代码自动办公 excel处理实例（二维表转一维表）项目源码有详细注解，适合新手一看就懂.rar

import openpyxl wb=openpyxl.load_workbook('业绩表.xlsx') ws=wb.worksheets[0] if '转换表' in wb.sheetnames: wb.remove(wb['转换表']) nws=wb.create_sheet('转换表');nws.append(['姓名','月份','业绩']) rng1=ws['a'][1:] rng2=ws.iter_rows(min_col=2,min_row=2) for name,row in list(zip(rng1,rng2)): for x,y in zip(ws[1][1:],row): nws.append([name.value,x.value,y.value]) wb.save('业绩表.xlsx')