五个方便好用的Python自动化办公脚本的实现

实现五个方便好用的Python自动化办公脚本攻略

1. 自动化发送邮件

import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

def send_email(subject, message, to_email):
    from_email = "[e-mail]"
    password = "your_email_password"

    msg = MIMEMultipart()
    msg['From'] = from_email
    msg['To'] = to_email
    msg['Subject'] = subject
    msg.attach(MIMEText(message, 'plain'))

    server = smtplib.SMTP('smtp.gmail.com', 587)
    server.starttls()
    server.login(from_email, password)
    server.sendmail(from_email, to_email, msg.as_string())
    server.quit()

# 使用示例
subject = "Test Email"
message = "This is a test email sent using Python."
to_email = "[e-mail]"
send_email(subject, message, to_email)

2. 自动化处理Excel数据

import pandas as pd

def process_excel(file_path):
    data = pd.read_excel(file_path)
    # 进行Excel数据处理
    # ...
    # 处理后的数据存储到新的Excel文件
    data.to_excel("processed_data.xlsx", index=False)

# 使用示例
file_path = "input_data.xlsx"
process_excel(file_path)

3. 自动化生成PDF报告

from fpdf import FPDF

def generate_pdf_report(title, content):
    pdf = FPDF()
    pdf.add_page()
    pdf.set_font("Arial", size=12)
    pdf.cell(200, 10, txt=title, ln=True, align='C')
    pdf.cell(200, 10, txt=content, ln=True, align='L')
    pdf.output("report.pdf")

# 使用示例
title = "Monthly Report"
content = "This is the content of the report."
generate_pdf_report(title, content)

4. 自动化处理Word文档

from docx import Document

def process_word_document(file_path):
    doc = Document(file_path)
    # 对Word文档进行处理
    # ...
    # 处理后的文档保存
    doc.save("processed_document.docx")

# 使用示例
file_path = "input_document.docx"
process_word_document(file_path)

5. 自动化管理文件和文件夹

import os
import shutil

def organize_files(source_folder, destination_folder):
    for root, dirs, files in os.walk(source_folder):
        for file in files:
            if file.endswith(".txt"):
                file_path = os.path.join(root, file)
                shutil.move(file_path, destination_folder)

# 使用示例
source_folder = "/path/to/source_folder"
destination_folder = "/path/to/destination_folder"
organize_files(source_folder, destination_folder)

以上就是实现五个方便好用的Python自动化办公脚本的方法，希望对您有所帮助！