从Outlook中的Excel附件创建数据帧

import pandas as pd
import win32com.client as win32
import os

def save_excel_attachment():
    outlook = win32.Dispatch("Outlook.Application").GetNamespace("MAPI")
    inbox = outlook.GetDefaultFolder(6)  # 6表示收件箱
    messages = inbox.Items
    for message in messages:
        attachments = message.Attachments
        for attachment in attachments:
            if attachment.FileName.endswith(".xlsx"):  # 仅处理Excel附件
                attachment.SaveAsFile(os.path.join("文件夹路径", attachment.FileName))

def excel_to_dataframe(file_path):
    df = pd.read_excel(file_path)  # 读取Excel文件
    return df

save_excel_attachment()  # 保存Excel附件到本地文件夹
file_path = os.path.join("文件夹路径", "Excel文件名.xlsx")  # 替换为实际的文件路径和文件名
df = excel_to_dataframe(file_path)  # 将Excel文件转换为数据帧