用 Python 玩转办公自动化：让你一键生成报表、邮件群发、文件批处理

bash复制编辑pip install pandas openpyxl python-docx pywin32 yagmail pillow

python复制编辑import pandas as pd

df = pd.read_excel("sales_data.xlsx")
summary = df.groupby("地区")[["销售额"]].sum().reset_index()
summary.to_excel("日报_汇总.xlsx", index=False)

python复制编辑from docx import Document

doc = Document()
doc.add_heading("销售日报", 0)

doc.add_paragraph("以下是今日各地区销售额：")

table = doc.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = '地区'
hdr_cells[1].text = '销售额'

for _, row in summary.iterrows():
    cells = table.add_row().cells
    cells[0].text = row["地区"]
    cells[1].text = str(row["销售额"])

doc.save("日报.docx")

python复制编辑from docx.shared import Inches
doc.add_picture("sales_plot.png", width=Inches(5))

python复制编辑import yagmail

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

python复制编辑df = pd.read_excel("客户列表.xlsx")  # 包含客户名和邮箱地址

for i, row in df.iterrows():
    name = row['姓名']
    email = row['邮箱']
    yag.send(
        to=email,
        subject="日报送达",
        contents=[
            f"{name}，您好，这是您今日的销售报告。",
            "请查收附件。",
        ],
        attachments="日报.docx"
    )

python复制编辑from docx import Document
import os

files = os.listdir("简历模板/")

for file in files:
    if file.endswith(".docx"):
        doc = Document(f"简历模板/{file}")
        doc.paragraphs[0].text = "张三的个人简历"  # 修改标题
        doc.save(f"简历模板/改后_{file}")

python复制编辑for p in doc.paragraphs:
    if "姓名" in p.text:
        p.text = p.text.replace("姓名", "张三")

python复制编辑import os
import shutil

source_folder = "下载文件"
target_folder = "整理后/"

for file in os.listdir(source_folder):
    ext = os.path.splitext(file)[1]
    folder = ext.strip('.').upper() + "_文件"

    new_dir = os.path.join(target_folder, folder)
    os.makedirs(new_dir, exist_ok=True)
    shutil.move(os.path.join(source_folder, file), os.path.join(new_dir, file))

css复制编辑[Excel 数据] → [Python 分析] → [Word 报告 + 图] → [邮件发送]

python复制编辑import schedule
import time

def task():
    print("正在生成并发送日报...")

schedule.every().day.at("09:00").do(task)

while True:
    schedule.run_pending()
    time.sleep(10)