Python 自动化办公实战指南：从基础到进阶

python复制编辑import os
import pandas as pd

python复制编辑def merge_excels(folder_path, output_file):
    all_data = []
    for file in os.listdir(folder_path):
        if file.endswith('.xlsx'):
            df = pd.read_excel(os.path.join(folder_path, file))
            all_data.append(df)
    merged_df = pd.concat(all_data)
    merged_df.to_excel(output_file, index=False)

python复制编辑merge_excels('每日销售数据/', '汇总报表.xlsx')

复制编辑尊敬的{{客户名称}}：

感谢您购买我们的产品，订单编号为 {{订单编号}}。

python复制编辑from docx import Document

def fill_word_template(template_path, output_path, replacements):
    doc = Document(template_path)
    for para in doc.paragraphs:
        for key, val in replacements.items():
            if key in para.text:
                para.text = para.text.replace(key, val)
    doc.save(output_path)

data = {
    "{{客户名称}}": "张三",
    "{{订单编号}}": "A20250610001"
}

fill_word_template("template.docx", "合同_张三.docx", data)

python复制编辑import yagmail

yag = yagmail.SMTP(user='your_email@example.com', password='your_password')

recipients = [
    {"email": "client1@example.com", "name": "张三"},
    {"email": "client2@example.com", "name": "李四"},
]

for r in recipients:
    subject = f"合同发送 - {r['name']}"
    contents = f"您好，{r['name']}，请查收您的合同。"
    yag.send(to=r["email"], subject=subject, contents=contents, attachments=f"合同_{r['name']}.docx")

python复制编辑import os
import shutil

source_folder = '合同草稿/'
target_folder = '合同归档/'

for file in os.listdir(source_folder):
    if file.endswith('.docx'):
        name = file.split('_')[1].replace('.docx', '')
        shutil.move(
            os.path.join(source_folder, file),
            os.path.join(target_folder, f"{name}_合同.docx")
        )

python复制编辑import schedule
import time

def job():
    print("开始合并数据...")
    merge_excels('每日销售数据/', '汇总报表.xlsx')

schedule.every().day.at("08:00").do(job)

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

python复制编辑import matplotlib.pyplot as plt

df = pd.read_excel('汇总报表.xlsx')
df.groupby('地区')['销售额'].sum().plot(kind='bar', color='skyblue')
plt.title('各地区销售汇总')
plt.ylabel('销售额')
plt.xticks(rotation=30)
plt.tight_layout()
plt.savefig('销售图表.png')
plt.show()

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

def run_merge():
    folder = filedialog.askdirectory()
    merge_excels(folder, "汇总报表.xlsx")
    messagebox.showinfo("完成", "合并完成！")

root = tk.Tk()
root.title("Excel合并工具")

btn = tk.Button(root, text="选择文件夹并合并", command=run_merge)
btn.pack(padx=20, pady=20)

root.mainloop()