def update_rate(name, rate):
import openpyxl
wb = openpyxl.load_workbook('豆瓣TOP250电影.xlsx')
sheet_list = wb.sheetnames
ws = wb]
for each in ws["A"]:
if each.value == name:
each.offset(0, 1).value = rate
wb.save('豆瓣TOP250电影.xlsx')
update_rate('阿甘正传', '9.8')
1