恳请各位大神帮忙解决一下

飞鱼python

# 导入模块
from openpyxl import load_workbook

# 获取数据
wb  = load_workbook('./material/江宇工资信息表.xlsx')
ws = wb['Sheet1']
ws['H1'].value = '总工资'

for row in ws.iter_rows(min_row=2,max_row=11 ,values_only=True):
    performance = row[4]
    bonus = row[5]
    base = row[6]

# 使用数据
    salary = performance + bonus + base
   


# 输出结果

wb.save('./material/江宇工资信息表.xlsx')


我该怎么样利用循环把所有人总工资都自动填入表格呀（具体是该怎么样赋值呢？）

txxcat

1. # 导入模块
   
2. from openpyxl import load_workbook
   
3. 
   
4. # 获取数据
   
5. wb  = load_workbook('./material/江宇工资信息表.xlsx')
   
6. ws = wb['Sheet1']
   
7. ws['H1'].value = '总工资'
   
8. 
   
9. # for row in ws.iter_rows(min_row=2,max_row=11 ,values_only=True):
   
10. #     performance = row[4]
    
11. #     bonus = row[5]
    
12. #     base = row[6]
    
13.    
    
14. for row in range(2,12):
    
15.     performance = ws['E'+str(row)].value
    
16.     bonus = ws['F'+str(row)].value
    
17.     base = ws['G'+str(row)].value
    
18.     salary = performance + bonus + base
    
19.     ws['H'+str(row)] = salary
    
20. 
    
21. # 输出结果
    
22. 
    
23. wb.save('./material/江宇工资信息表.xlsx')
    

复制代码

飞鱼python

txxcat 发表于 2021-4-26 22:17

谢谢，已经很好了，给我提供了很好的思路