如何使用Python 3.7将excel文件附加到Gmail？

import os
import base64
import mimetypes
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.errors import HttpError

# 设置Gmail API权限范围
SCOPES = ['https://www.googleapis.com/auth/gmail.compose']

def create_message_with_attachment(sender, to, subject, message_text, file_path):
    message = MIMEMultipart()
    message['to'] = to
    message['from'] = sender
    message['subject'] = subject

    msg = MIMEText(message_text)
    message.attach(msg)

    content_type, encoding = mimetypes.guess_type(file_path)
    if content_type is None or encoding is not None:
        content_type = 'application/octet-stream'

    main_type, sub_type = content_type.split('/', 1)
    with open(file_path, 'rb') as fp:
        file_data = fp.read()

    if main_type == 'text':
        attachment = MIMEText(file_data, _subtype=sub_type)
    elif main_type == 'image':
        attachment = MIMEImage(file_data, _subtype=sub_type)
    elif main_type == 'audio':
        attachment = MIMEAudio(file_data, _subtype=sub_type)
    else:
        attachment = MIMEBase(main_type, sub_type)
        attachment.set_payload(file_data)

    filename = os.path.basename(file_path)
    attachment.add_header('Content-Disposition', 'attachment', filename=filename)
    message.attach(attachment)

    return {'raw': base64.urlsafe_b64encode(message.as_string().encode()).decode()}

def send_message(service, user_id, message):
    try:
        message = service.users().messages().send(userId=user_id, body=message).execute()
        print('Message sent successfully. Message ID: %s' % message['id'])
        return message
    except HttpError as error:
        print('An error occurred: %s' % error)

def main():
    # 读取客户端密钥文件
    credentials = Credentials.from_authorized_user_file('client_secret.json', SCOPES)
    
    # 构建Gmail API客户端
    service = build('gmail', 'v1', credentials=credentials)

    # 发送者和收件人信息
    sender = 'your_email@gmail.com'
    to = 'recipient_email@example.com'

    # 邮件内容
    subject = '附件示例'
    message_text = '这是一封带有附件的邮件。'
    file_path = 'path_to_your_excel_file.xlsx'

    # 创建带附件的邮件消息
    message = create_message_with_attachment(sender, to, subject, message_text, file_path)

    # 发送邮件
    send_message(service, 'me', message)

if __name__ == '__main__':
    main()