g = quick + 'D' + str(i + 2) + ')'
            listB.append(e)
            listA.append(d)
            listC.append(f)
            listD.append(g)
            progressbarTwo['value'] += 1  # 进度条+1
            window.update()

    df2 = pd.DataFrame({'方法编号': list_3, '链接': listA, '跳转': listB,'phone':listC,'phoneurl':listD})
    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='BaiDu', index=0)
    worksheet = book['BaiDu']
    worksheet.column_dimensions['A'].width = 25
    worksheet.column_dimensions['B'].width = 10
    worksheet.column_dimensions['C'].width = 100
    worksheet.column_dimensions['D'].width = 10
    worksheet.column_dimensions['E'].width = 100
    writer.save()
    progressbarOne['value'] += 1  # 进度条+1
    window.update()

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