Python自动办公实例-excel处理实例（筛选成绩总分大于等于300分的记录）.zip

import openpyxl wb=openpyxl.load_workbook('test.xlsx') ws=wb.active rngs=list(ws.rows) nws=wb.create_sheet('筛选结果') nws.append([c.value for c in rngs[0]]+['总分']) for row in rngs[1:]: l=[c.value for c in row] l+=[sum(l[1:])] if l[-1]>=300: nws.append(l) wb.save('test1.xlsx')