Python 爬取1688货源重量，自动发邮件到指定邮箱（qq），设置定时运行程序

# -*- coding: utf-8 -*-
# @Time : 2020/7/6 13:46
# @Author : Chunfang
# @Email : 3470959534@qq.com
# @File : test02.py
# @Software: PyCharm

import os,xlrd,time
import re
import datetime
from openpyxl import load_workbook
from selenium import webdriver
from time import sleep
from selenium.webdriver.chrome.service import Service

def down_data():
    start = datetime.datetime.now()
    filepath2 = 'SKU-URL-weight.xlsx'                # 新建表格，将唯一的sku，url写入

    wb2 = load_workbook(filepath2)
    ws2 = wb2.worksheets[0]

    def down_data(url):         # 获取每个链接的数据
        # 加载浏览器带表头数据爬虫
        c_service = Service(r'D:\Python\Scripts\chromedriver.exe')
        c_service.command_line_args()
        c_service.start()
        profile_directory = r'--user-data-dir=C:\Users\Administrator\AppData\Local\Google\Chrome\User Data'
        option = webdriver.ChromeOptions()
        option.add_argument(profile_directory)
        driver = webdriver.Chrome(options=option)
        driver.implicitly_wait(3)
        driver.get(url)
        sleep(3)
        data = driver.page_source
        sleep(2)
        driver.quit()
        sleep(2)
        c_service.stop()
        return data
    def station(data):
        busy = re.findall('<div class="tips" style=".*?<p>.*?(亲.*?回来).*?</p>', data, re.S)
        # print(busy)
        error_404 = re.findall('h3 class="title">.*?<em>(抱歉.*?)</em>', data, re.S)
        # print(error_404)
        pro_weight = re.findall('<span>.*?<b>.*?重量</b>.*?<em>(.*?)</em>', data, re.S)
        # print(pro_weight)
        right = re.findall('title="点击此按钮.*?rel="nofollow"><span>(.*?订购)</span></a>', data, re.S)
        # print(right)
        stations.append(busy)
        stations.append(error_404)
        stations.append(pro_weight)
        stations.append(right)

    for i in range(16635,ws2.max_row+1):
        print('第' + str(i) + '个sku：' + str(ws2.cell(i, 1).value))
        stations = []
        data=down_data(ws2.cell(i,2).value)
        # print(data)
        station(data)
        while len(stations[0])!=0:#没有加载出来
            stations = []
            data = down_data(ws2.cell(i, 2).value)
            station(data)
            print(stations)
        if len(stations[1])==0:#判断404
            if len(stations[2])==0:#判断重量
                if len(stations[3])==0:#判断产品是否有货，可订购
                    ws2.cell(i, 3).value = '产品下架'
                else:
                    ws2.cell(i,3).value = '产品有货，没有标注重量'
            else:
                ws2.cell(i, 3).value = stations[2][1]#添加重量
        else:
            ws2.cell(i,3).value = stations[1][0]#抱歉404
        print(stations)

        wb2.save(filepath2)

    end = datetime.datetime.now()
    print('Running time: %s Seconds'%(end-start))

    #发邮件给对方邮箱
    import smtplib
    from email.mime.text import MIMEText
    from email.mime.multipart import MIMEMultipart
    from email.mime.image import MIMEImage
    from email.mime.application import MIMEApplication

    #设置服务器所需信息
    fromaddr ='3470959534@qq.com'
    password = '验证码'#qq的邮箱验证码
    toaddrs = ['3470959534@qq.com','1725714926@qq.com']

    #邮件内容设置
    message = MIMEText('hello! 这是跑货源结果，请查收','plain','utf-8')
    message['Subject']='测试邮件'

    excel_file =filepath2
    excel_apart = MIMEApplication(open(excel_file,'rb').read())
    excel_apart.add_header('Content-Disposition','atttachment',filename=excel_file)

    m = MIMEMultipart()
    m.attach(message)
    m.attach(excel_apart)

    try:
        server = smtplib.SMTP('smtp.qq.com')
        server.login(fromaddr,password)
        server.sendmail(fromaddr,toaddrs,m.as_string(),)
        print('success')
        server.quit()
    except smtplib.SMTPException as e:
        print('error:',e)

down_data()
#设置时间跑店小秘货源
# while True:
#     time_now = time.strftime('%H:%M:%S',time.localtime())
#
#     if time_now =="20:00:10":
#         down_data()
#         # print('Hello')
#         subject = time.strftime("%Y-%m-%d %H:%M:%S",time.localtime())+'定时发送测试'
#         print(subject)
#         time.sleep(2)