第12章 更新商品价格表

import openpyxl
wb = openpyxl.load_workbook("produceSales.xlsx")
sheet = wb['Sheet']
product_price = {'Garlic': 3.07,
                 'Celery': 1.19,
                 'Lemon': 1.27}
for row in range(2,sheet.max_row+1):
    produceName = sheet.cell(row,1).value
    if produceName in product_price:
        sheet.cell(row,2).value = product_price[produceName]
print("====修改完成！=====")
wb.save("updateProduceSales.xlsx")