10个Python办公自动化实战案例解析

import pandas as pd

# 读取Excel文件
df = pd.read_excel('example.xlsx')

# 进行简单的数据处理
df['New Column'] = df['Old Column'] * 2

# 保存修改后的数据
df.to_excel('modified_example.xlsx', index=False)

from fpdf import FPDF

# 创建PDF对象
pdf = FPDF()
pdf.add_page()

# 设置字体
pdf.set_font('Arial', size=12)

# 添加文本
pdf.cell(200, 10, txt="Hello World!", ln=True, align='C')

# 保存PDF文件
pdf.output("example.pdf")

import smtplib
from email.mime.text import MIMEText

# 设置邮件内容
msg = MIMEText("Hello, this is an automated email.")
msg['Subject'] = 'Automated Email'
msg['From'] = 'you@example.com'
msg['To'] = 'recipient@example.com'

# 发送邮件
with smtplib.SMTP('smtp.example.com', 587) as server:
    server.starttls()
    server.login("you@example.com", "password")
    server.send_message(msg)

import os

# 定义文件路径
folder_path = '/path/to/folder'

# 遍历文件并重命名
for filename in os.listdir(folder_path):
    new_name = "new_" + filename
    os.rename(os.path.join(folder_path, filename), os.path.join(folder_path, new_name))

import requests

urls = ['https://example.com/page1', 'https://example.com/page2']

for url in urls:
    response = requests.get(url)
    with open(url.split('/')[-1] + '.html', 'w') as file:
        file.write(response.text)

import matplotlib.pyplot as plt

# 数据
x = [1, 2, 3, 4, 5]
y = [10, 20, 25, 30, 40]

# 绘制折线图
plt.plot(x, y)
plt.xlabel('X axis')
plt.ylabel('Y axis')
plt.title('Automated Plot')

# 保存图片
plt.savefig('plot.png')

from docx import Document

# 创建Word文档
doc = Document()
doc.add_heading('Automated Report', 0)
doc.add_paragraph('This is an automated report generated by Python.')

# 保存文档
doc.save('report.docx')

import zipfile
import os

# 压缩文件夹中的所有文件
with zipfile.ZipFile('archive.zip', 'w') as zipf:
    for root, dirs, files in os.walk('/path/to/folder'):
        for file in files:
            zipf.write(os.path.join(root, file))

import time
import win10toast

toaster = win10toast.ToastNotifier()

# 定时提醒
time.sleep(5)
toaster.show_toast("Reminder", "Time to attend the meeting!", duration=10)

import shutil
import time

# 定义源路径和备份路径
source_path = '/path/to/data'
backup_path = '/path/to/backup'

# 定时备份操作
while True:
    shutil.copytree(source_path, backup_path)
    print('Data backup completed.')
    time.sleep(3600)  # 每隔一小时备份一次