pip install openpyxl pandas python-dotenv

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
 
def send_email(sender_email, sender_password, recipient_email, subject, body):
    # 創(chuàng)建郵件對(duì)象
    msg = MIMEMultipart()
    msg['From'] = sender_email
    msg['To'] = recipient_email
    msg['Subject'] = subject
    msg.attach(MIMEText(body, 'plain'))
 
    # 連接到 SMTP 服務(wù)器并發(fā)送郵件
    try:
        with smtplib.SMTP('smtp.gmail.com', 587) as server:
            server.starttls()
            server.login(sender_email, sender_password)
            server.send_message(msg)
        print("郵件發(fā)送成功！")
    except Exception as e:
        print(f"郵件發(fā)送失?。簕e}")
 
# 調(diào)用示例
send_email(
    sender_email='your_email@gmail.com',
    sender_password='your_app_password',
    recipient_email='recipient@example.com',
    subject='測(cè)試郵件',
    body='這是一封通過(guò) Python 發(fā)送的測(cè)試郵件。'
)

import imaplib
import email
 
def fetch_emails(email_address, password):
    try:
        # 連接 IMAP 服務(wù)器
        with imaplib.IMAP4_SSL('imap.gmail.com') as mail:
            mail.login(email_address, password)
            mail.select('inbox')  # 選擇收件箱
 
            # 搜索未讀郵件
            status, messages = mail.search(None, 'UNSEEN')
            for num in messages[0].split():
                status, msg_data = mail.fetch(num, '(RFC822)')
                for response_part in msg_data:
                    if isinstance(response_part, tuple):
                        msg = email.message_from_bytes(response_part[1])
                        print(f"發(fā)件人: {msg['from']}")
                        print(f"主題: {msg['subject']}")
                        if msg.is_multipart():
                            for part in msg.walk():
                                if part.get_content_type() == 'text/plain':
                                    print(f"內(nèi)容: {part.get_payload(decode=True).decode()}")
                        else:
                            print(f"內(nèi)容: {msg.get_payload(decode=True).decode()}")
    except Exception as e:
        print(f"郵件讀取失?。簕e}")
 
# 調(diào)用示例
fetch_emails('your_email@gmail.com', 'your_app_password')

import openpyxl
 
# 打開(kāi) Excel 文件
workbook = openpyxl.load_workbook('example.xlsx')
sheet = workbook.active
 
# 讀取數(shù)據(jù)
for row in sheet.iter_rows(min_row=1, max_row=5, min_col=1, max_col=3):
    print([cell.value for cell in row])
 
# 寫(xiě)入數(shù)據(jù)
sheet['A6'] = '新數(shù)據(jù)'
workbook.save('example_updated.xlsx')
print("Excel 文件已更新！")

import pandas as pd
 
# 讀取 Excel 文件
data = pd.read_excel('example.xlsx')
 
# 打印前五行數(shù)據(jù)
print(data.head())
 
# 數(shù)據(jù)處理
data['總分'] = data['數(shù)學(xué)'] + data['英語(yǔ)'] + data['科學(xué)']
print(data)
 
# 保存結(jié)果
data.to_excel('processed.xlsx', index=False)
print("數(shù)據(jù)處理完成并已保存！")

import os
import imaplib
import email
import pandas as pd
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import smtplib
 
def fetch_and_process_email(email_address, password):
    # 連接 IMAP
    with imaplib.IMAP4_SSL('imap.gmail.com') as mail:
        mail.login(email_address, password)
        mail.select('inbox')
 
        # 搜索含附件郵件
        status, messages = mail.search(None, 'ALL')
        for num in messages[0].split():
            status, msg_data = mail.fetch(num, '(RFC822)')
            for response_part in msg_data:
                if isinstance(response_part, tuple):
                    msg = email.message_from_bytes(response_part[1])
                    if msg.is_multipart():
                        for part in msg.walk():
                            if part.get_filename():  # 找到附件
                                file_path = os.path.join(os.getcwd(), part.get_filename())
                                with open(file_path, 'wb') as f:
                                    f.write(part.get_payload(decode=True))
                                print(f"附件已保存: {file_path}")
 
                                # 處理附件數(shù)據(jù)
                                data = pd.read_excel(file_path)
                                data['總分'] = data.sum(axis=1)
                                processed_path = 'processed.xlsx'
                                data.to_excel(processed_path, index=False)
                                print("數(shù)據(jù)處理完成")
 
                                # 返回處理結(jié)果
                                send_email(
                                    sender_email=email_address,
                                    sender_password=password,
                                    recipient_email=msg['from'],
                                    subject='數(shù)據(jù)處理結(jié)果',
                                    body='附件已處理，請(qǐng)查看。',
                                    attachment_path=processed_path
                                )
 
def send_email(sender_email, sender_password, recipient_email, subject, body, attachment_path):
    msg = MIMEMultipart()
    msg['From'] = sender_email
    msg['To'] = recipient_email
    msg['Subject'] = subject
    msg.attach(MIMEText(body, 'plain'))
 
    # 添加附件
    with open(attachment_path, 'rb') as f:
        attachment = email.mime.base.MIMEBase('application', 'octet-stream')
        attachment.set_payload(f.read())
        email.encoders.encode_base64(attachment)
        attachment.add_header('Content-Disposition', f'attachment; filename={os.path.basename(attachment_path)}')
        msg.attach(attachment)
 
    # 發(fā)送郵件
    with smtplib.SMTP('smtp.gmail.com', 587) as server:
        server.starttls()
        server.login(sender_email, sender_password)
        server.send_message(msg)
    print("郵件已發(fā)送！")
 
# 調(diào)用示例
fetch_and_process_email('your_email@gmail.com', 'your_app_password')