Button(window, text='选择路径', command=select_file, font=ft).place(relx=0.8, width=80, rely=0.15)
btn0 = Button(window, text='运行', font=ft, command=lambda: [father()]).place(
    relx=0.45, rely=0.7)
Label(window, text='version:1.0.0.0', font=ft).place(relx=0.41, rely=0.85)

3.实现，以百度为例:

df = pd.read_excel(varF_1.get())

progressbarTwo['maximum'] = len(list_3)  # 进度值最大值

progressbarTwo['value'] = 0  # 进度值初始值

df1 = list(np.array(df['标准代号'].str.split('n')))#当有合并单元格的时候，以n切片元素

list_2 = [x for item in df1 for x in item]#去掉list内括号

list_3 = [x.strip() for x in list_2 if x.strip() != '']#去掉''元素

# list_3 = list(set(list_2))

list_3 = list(set(list_3))#去重

list_3.sort(key=None, reverse=False)#排序

listA = []

listB = []

listC = []

listD = []

url = 'https://www.baidu.com/s?tn=51076811_dg&wd='

url2 = 'https://www.baidu.com/s?ie=utf-8&f=8&rsv_bp=1&tn=51076811_dg&wd='

url3 = 'https://m.baidu.com/ssid=21ec6c6478732f17/from=1001192y/s?word='

quick = '=HYPERLINK('#写入excel时转换为超链接

for i in range(len(list_3)):

    if not 'u4e00' <= list_3[i][2] <= 'u9fff':#判断第二个字符是否为汉字

        a = str(list_3[i]).replace('/', '%2F')#替换'/'为'%2F'

        c = a.replace('  ', '+')#替换'  '为','

        b = c.replace(' ', '+')#替换' '为','

        d = url + b + '%20-advertisement'#合并链接

        f = url3 + b + '+-advertisemen'

        e = quick + 'B' + str(i + 2) + ')'#转换为超链接

        g = quick + 'D' + str(i + 2) + ')'

        listB.append(e)

        listA.append(d)

        listC.append(f)

        listD.append(g)