else:
            d = url + list_3[i] + '%20-advertisement'
            e = quick + 'B' + str(i + 2) + ')'
            listB.append(e)
            listA.append(d)
            progressbarTwo['value'] += 1  # 进度条+1
            window.update()

    df2 = pd.DataFrame({'方法编号': list_3, '链接': listA, '跳转': listB})
    print(df2)

    book = load_workbook(varF_1.get())
    writer = pd.ExcelWriter(varF_1.get(), engine='openpyxl')
    writer.book = book
    df2.to_excel(writer, sheet_name='Google', index=0)
    worksheet = book['Google']
    worksheet.column_dimensions['A'].width = 25
    worksheet.column_dimensions['B'].width = 10
    worksheet.column_dimensions['C'].width = 100
    writer.save()
    progressbarOne['value'] += 1  # 进度条+1
    window.update()

    progressbarTwo['maximum'] = len(list_3)  # 进度值最大值
    progressbarTwo['value'] = 0  # 进度值初始值
    df1 = list(np.array(df['标准代号'].str.split('n')))