else:

        d = url2 + list_3[i] + '%20-advertisement'

        f = url3 + urllib.parse.quote(list_3[i].encode('gb2312'))+ '+-advertisemen'#将中文转义

        print(f)

        e = quick + 'B' + str(i + 2) + ')'

        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()

三、常见搜索网站头部：