Excel 自动化（openpyxl + pandas）

pip install openpyxl pandas
import pandas as pd
df = pd.read_excel('销售数据.xlsx')
df['销售额'] = df['数量'] * df['单价']
monthly = df.groupby('月份')['销售额'].sum()
monthly.to_excel('月度报表.xlsx')

批量合并 Excel

import glob, pandas as pd
files = glob.glob('data/*.xlsx')
result = pd.concat([pd.read_excel(f) for f in files], ignore_index=True)
result.to_excel('合并结果.xlsx', index=False)

Word 模板填充

from docx import Document
doc = Document('合同模板.docx')
for para in doc.paragraphs:
    for run in para.runs:
        run.text = run.text.replace('{{公司名称}}', '杜兴华写代码工作室')
doc.save('合同_已填充.docx')

PDF 内容提取

import fitz
doc = fitz.open('报告.pdf')
text = ''.join(page.get_text() for page in doc)

关注公众号「杜兴华写代码」，回复「自动化」获取完整代码。