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='SoGou', index=0)
    worksheet = book['SoGou']
    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()


window.mainloop()