|
- import openpyxl
- Path = r'C:\Users\Dr.Oscar\Documents\123.xlsx'
- wb = openpyxl.load_workbook(Path)
- ws = wb['Sheet3']
- for x in range(1,ws.max_row):
- if ws.cell(x,1).value == '张五':
- ws.cell(x,3).value = '红星学校'
- ws.cell(x,4).value = '六三班'
- break
- wb.save(Path)
复制代码
是这样吧!
|
|