Python 自动化办公实战：用 Python 提效 10 倍的办公神器项目

bash复制编辑pip install openpyxl pandas xlrd pywin32

bash复制编辑pip install yagmail pillow docx

复制编辑📂打卡数据
├── 1月.xlsx
├── 2月.xlsx
├── ...

python复制编辑import pandas as pd
import os

folder = './打卡数据'
all_files = [f for f in os.listdir(folder) if f.endswith('.xlsx')]

df_list = []

for file in all_files:
    path = os.path.join(folder, file)
    df = pd.read_excel(path)
    df['月份'] = file.replace('.xlsx', '')
    df_list.append(df)

merged_df = pd.concat(df_list)
merged_df.to_excel("打卡合并总表.xlsx", index=False)

python复制编辑summary = merged_df.groupby('部门')['打卡天数'].sum().reset_index()
summary.to_excel("部门打卡汇总.xlsx", index=False)

python复制编辑import yagmail

yag = yagmail.SMTP(user="your_email@qq.com", password="授权码")

yag.send(
    to="user@example.com",
    subject="月度打卡通知",
    contents="您好，本月打卡报告请查收！",
    attachments="打卡合并总表.xlsx"
)

python复制编辑contacts = pd.read_excel("收件人表.xlsx")

for _, row in contacts.iterrows():
    name = row['姓名']
    email = row['邮箱']
    content = f"{name}，您好，本月打卡数据已发送，请查收！"

    yag.send(
        to=email,
        subject="【公司通知】月度打卡报告",
        contents=content,
        attachments="打卡合并总表.xlsx"
    )

python复制编辑from docx import Document

doc = Document()
doc.add_heading("员工工作证明", 0)
doc.add_paragraph("兹证明 XXX 为我司正式员工，表现良好。")
doc.save("证明文档.docx")

python复制编辑template = Document("证明模板.docx")
contacts = pd.read_excel("员工名单.xlsx")

for _, row in contacts.iterrows():
    name = row['姓名']
    new_doc = Document("证明模板.docx")
    
    for p in new_doc.paragraphs:
        if '【姓名】' in p.text:
            p.text = p.text.replace("【姓名】", name)
    
    new_doc.save(f"{name}_工作证明.docx")

python复制编辑from PIL import Image
import os

src_folder = './images'
dst_folder = './processed'

os.makedirs(dst_folder, exist_ok=True)

for i, filename in enumerate(os.listdir(src_folder)):
    if filename.endswith(".jpg"):
        img = Image.open(os.path.join(src_folder, filename))
        img = img.resize((600, 400))
        new_name = f"img_{i+1}.jpg"
        img.save(os.path.join(dst_folder, new_name), quality=85)

python复制编辑import shutil

folder = './资料包'
for file in os.listdir(folder):
    full_path = os.path.join(folder, file)
    if file.endswith('.pdf'):
        shutil.move(full_path, './PDF文件/' + file)
    elif file.endswith('.docx'):
        shutil.move(full_path, './Word文件/' + file)

python复制编辑import tkinter as tk
from tkinter import filedialog

def choose_file():
    file = filedialog.askopenfilename()
    print("选择的文件：", file)

win = tk.Tk()
win.title("自动办公工具")
tk.Button(win, text="选择文件", command=choose_file).pack(padx=20, pady=20)
win.mainloop()

bash复制编辑crontab -e

ruby复制编辑0 9 * * * /usr/bin/python3 /home/user/job.py