Python自动办公-41 excel处理实例（单工作表拆分到多工作表）.zip

import openpyxl wb=openpyxl.load_workbook('各班成绩表.xlsx') ws=wb.active rngs=list(ws.values) d={} for row in rngs[1:]: if row[0] in d.keys(): d[row[0]]+=[row] else: d[row[0]]=[row] nwb=openpyxl.Workbook() for k,v in sorted(d.items()): nws=nwb.create_sheet(k) nws.append(rngs[0]) for r in v: nws.append(r) nwb.remove(nwb.worksheets[0]) nwb.save('拆分.xlsx')