9.8 作业

import openpyxl

wb = openpyxl.load_workbook('/root/Desktop/produceSales.xlsx')
sheet = wb.active
infos = ([cell.value for cell in row] for row in sheet.rows)
dic = {'Celery':1.19, 'Garlic':3.07, 'Lemon':1.27}
for index, item in enumerate(infos):
    if item[0] in dic:
        sheet.cell(row=index+1, column=2, value=dic[item[0]])
wb.save(filename='/root/Desktop/produceSales.xlsx')