【RPA实战】使用RPA + selenium登录QQ邮箱并获取所有邮件信息存储到excel发送到指定邮箱

from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import time
import openpyxl
from openpyxl import Workbook
import smtplib
from email.mime.multipart import MIMEMultipart
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
from selenium.webdriver.common.action_chains import ActionChains
import pyautogui
import time
import pyperclip

# 启动浏览器
driver = webdriver.Chrome(r"D:\数据机器人\SeleniumDriver\chromedriver\104.0.5112.79\chromedriver.exe")

# 打开 QQ 邮箱登录页面
driver.get("https://mail.qq.com/")
time.sleep(0.5)
# 最大化当前页面
driver.maximize_window()

# 等待登录框加载完成
iframe = driver.find_element(By.XPATH, '//iframe[@class="QQMailSdkTool_login_loginBox_qq_iframe"]')
driver.switch_to.frame(iframe)

iframe = driver.find_element(By.XPATH, '//iframe[@id="ptlogin_iframe"]')
driver.switch_to.frame(iframe)

# 点击密码登录按钮
driver.find_element(By.XPATH,'//a[@id="switcher_plogin"]').click()


# 输入QQ号和密码并登录
driver.find_element(By.ID, 'u').send_keys('************')
driver.find_element(By.ID, 'p').send_keys('*************')
driver.find_element(By.ID, 'login_button').click()

time.sleep(5)
# 进入收件箱
driver.find_element_by_id("folder_1").click()

# 等待收件箱加载完成
time.sleep(5)

# 创建 Excel 工作簿
wb = Workbook()
ws = wb.active

first_div_iframe = driver.find_element(By.XPATH, '//div[@id="mainFrameContainer"]//iframe')
driver.switch_to.frame(first_div_iframe)
print("ok")



# 获取所有符合条件的表格元素
tables = driver.find_elements(By.XPATH, "//table[@class='i M']")
print(tables)
for table in tables:
    # 创建一个新的行来存储表格中的数据
    new_row = []
    # 获取表格中的所有文本内容并添加到新行中
    for row in table.find_elements(By.XPATH, ".//tr"):
        row_data = []
        for cell in row.find_elements(By.XPATH, ".//td"):
            row_data.append(cell.text.strip())
        # 将本行数据添加到新行中
        new_row.append(row_data)
    # 将新行数据写入 Excel 工作表中
    for row_data in new_row:
        ws.append(row_data)

# 保存 Excel 文件
# 保存 Excel 文件
wb.save(r"C:\Users\Desktop\emial.xlsx")

# 关闭浏览器
driver.quit()

from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import time
import openpyxl
from openpyxl import Workbook
import smtplib
from email.mime.multipart import MIMEMultipart
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
from selenium.webdriver.common.action_chains import ActionChains
import pyautogui
import time
import pyperclip

# 启动浏览器
driver = webdriver.Chrome(r"D:\数据机器人\SeleniumDriver\chromedriver\104.0.5112.79\chromedriver.exe")

# 打开 QQ 邮箱登录页面
driver.get("https://mail.qq.com/")
time.sleep(0.5)
# 最大化当前页面
driver.maximize_window()

# 等待登录框加载完成
iframe = driver.find_element(By.XPATH, '//iframe[@class="QQMailSdkTool_login_loginBox_qq_iframe"]')
driver.switch_to.frame(iframe)

iframe = driver.find_element(By.XPATH, '//iframe[@id="ptlogin_iframe"]')
driver.switch_to.frame(iframe)

# 点击密码登录按钮
driver.find_element(By.XPATH,'//a[@id="switcher_plogin"]').click()


# 输入QQ号和密码并登录
driver.find_element(By.ID, 'u').send_keys('自己的账号')
driver.find_element(By.ID, 'p').send_keys('密码.')
driver.find_element(By.ID, 'login_button').click()



time.sleep(5)
# 进入收件箱
driver.find_element_by_id("folder_1").click()

# 等待收件箱加载完成
time.sleep(5)

# 创建 Excel 工作簿
wb = Workbook()
ws = wb.active

first_div_iframe = driver.find_element(By.XPATH, '//div[@id="mainFrameContainer"]//iframe')
driver.switch_to.frame(first_div_iframe)
print("ok")



# 获取所有符合条件的表格元素
tables = driver.find_elements(By.XPATH, "//table[@class='i M']")
print(tables)
for table in tables:
    # 创建一个新的行来存储表格中的数据
    new_row = []
    # 获取表格中的所有文本内容并添加到新行中
    for row in table.find_elements(By.XPATH, ".//tr"):
        row_data = []
        for cell in row.find_elements(By.XPATH, ".//td"):
            row_data.append(cell.text.strip())
        # 将本行数据添加到新行中
        new_row.append(row_data)
    # 将新行数据写入 Excel 工作表中
    for row_data in new_row:
        ws.append(row_data)

# 保存 Excel 文件
# 保存 Excel 文件
wb.save(r"C:\Users\JackPeesao\Desktop\emial.xlsx")

# 关闭浏览器
driver.quit()

# 发送邮件
def send_email():
    # 设置发件人和收件人
    sender_email = "邮箱@qq.com"
    receiver_email = "收件@163.com"

    # 创建邮件对象
    msg = MIMEMultipart()
    msg['From'] = sender_email
    msg['To'] = receiver_email
    msg['Subject'] = "QQ邮箱收件信息"

    # 添加邮件正文
    body = "请查收附件中的 QQ 邮箱收件信息。"
    msg.attach(MIMEText(body, 'plain'))

    # 添加附件
    filename = r"C:\Users\JackPeesao\Desktop\emial.xlsx"
    attachment = open(filename, "rb")
    part = MIMEBase('application', 'octet-stream')
    part.set_payload(attachment.read())
    encoders.encode_base64(part)
    part.add_header('Content-Disposition', f'attachment; filename= {filename}')
    msg.attach(part)

    # 发送邮件
    server = smtplib.SMTP('smtp.qq.com', 587)
    server.starttls()
    server.login(sender_email, "授权码")
    text = msg.as_string()
    server.sendmail(sender_email, receiver_email, text)
    server.quit()

# 调用发送邮件函数
send_email()