#!python3#updateProduce.py-更正指定产品 成本价格（第二列）import openpyxlwb=openpyxl.load_workbook('produceSales.xlsx')sheet=wb.active #或sheet=wb['Sheet']# 需要更新成本价格的产品，字典格式PRICE_UPDATES = {
   'Garlic': 3.07,                 'Celery': 1.19,                 'Lemon': 1.27}#循环每一行，找到产品名等于字典键(key)的，更新其值（value）print('更新中，请稍后……')for rowNum in range(2,sheet.max_row):    proName=sheet.cell(row=rowNum,column=1).value    if proName in PRICE_UPDATES:        sheet.cell(row=rowNum,column=2).value=PRICE_UPDATES[proName]        #把更新成本后表格，保存到复制的表wb.save('produceSales_update.xlsx')print('完成更新！/n 请在表【produceSales_update.xlsx】内查看')

 

问用户年龄和口令，直到他们提供有效的输入

'''下面的程序反复询问用户年龄和口令，直到他们提供有效的输入保存为 validateInput.py'''while True:    print('Enter your age:')    age = input()    if age.isdecimal():        break    print('Please enter a number for your age.')    while True:    print('Select a new password (letters and numbers only):')    password = input()    if password.isalnum():        break    print('Passwords can only have letters and numbers.')'''输出Enter your age:mnPlease enter a number for your age.Enter your age:12Select a new password (letters and numbers only):;ll;;Passwords can only have letters and numbers.Select a new password (letters and numbers only):dsf123'''