python操作excel，查询新增

import os
import openpyxl
import datetime

path = r"D:\stzf"
os.chdir(path)  # 修改工作路径

while True:
    workbook = openpyxl.load_workbook('数据库 - 副本.xlsx')	# 返回一个workbook数据类型的值
    sheet1=workbook['现有数据']
    sheet2=workbook['查询记录']

    cell = sheet1['B']
    name=[]

    for i in cell:
        name.append(i.value)

    # print('name len:' + str(len(name)))

    timenow = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
    # print(timenow)

    nameflag=0
    inputname=input('请输入名字：')
    querydata=['',inputname,'',timenow]
    # print('querydata:' + querydata)
    sheet2.append(querydata)
    workbook.save('数据库 - 副本.xlsx')
    for i in name:
        if inputname == i:
            nameflag=1

    if nameflag==0:
        newdata = ['', inputname, '']
        sheet1.append(newdata)
        workbook.save('数据库 - 副本.xlsx')
        print('无重名！')
    else:
        print('有重名！')

    answer = input('是否继续查找？y/n\n')
    if answer == 'y':
        continue
    else:
        break