后续跟进爬虫

#import requests
import openpyxl
from bs4 import BeautifulSoup
from lxml import html
import time
from selenium import webdriver
wb=openpyxl.load_workbook('4月3日6点速卖通.xlsx')
sheet=wb['Sheet1']
col=sheet['A']
headers={'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36'}
driver=webdriver.Chrome()
# wb1=openpyxl.Workbook()   #建工作簿
# sheeta=wb.active
for url in col:
    #resp=requests.get(url.value,headers=headers)
    #rest=resp.text
    #print(rest)
    #print(url)
    driver.get(url.value)
    # et=html.etree
    # htmls=et.HTML(driver.page_source)
    bs=BeautifulSoup(driver.page_source,'lxml')
    try:
        soldb=bs.find('span',class_="product-reviewer-sold")
        sold=soldb.text
    except:
        sold=0
    #sold=htmls.xpath('//span[@class="product-reviewer-sold"]')
    print(sold)
    fensb=bs.find('p',class_="num-followers")
    fens=fensb.find('i').text

    sheet.append({'E':sold,'F':fens})

    #print(fens.text)
    time.sleep(4)
wb.save('4月7.xlsx')`在这里插入代码片`