# 辦公自動(dòng)化必備庫
pip install pandas openpyxl python-docx python-pptx pypdf2 python-dotenv smtplib

from docx import Document

# 1. 新建Word文檔
doc = Document()

# 2. 添加標(biāo)題、段落
doc.add_heading("自動(dòng)化生成的報(bào)告", 0)
doc.add_paragraph("這是Python自動(dòng)生成的正文內(nèi)容")

# 3. 批量替換文字（模板改合同神器）
for paragraph in doc.paragraphs:
    if "[姓名]" in paragraph.text:
        paragraph.text = paragraph.text.replace("[姓名]", "張三")

# 4. 保存文檔
doc.save("生成文檔.docx")

from PyPDF2 import PdfMerger

# 合并多個(gè)PDF
merger = PdfMerger()
pdf_list = ["1.pdf", "2.pdf", "3.pdf"]
for pdf in pdf_list:
    merger.append(pdf)
merger.write("合并完成.pdf")
merger.close()

import smtplib
from email.mime.text import MIMEText

# 配置郵箱
smtp_server = "smtp.qq.com"  # 163/QQ/企業(yè)郵箱都支持
sender = "你的郵箱@qq.com"
password = "郵箱授權(quán)碼"

# 編寫郵件
msg = MIMEText("Python自動(dòng)發(fā)送的郵件內(nèi)容", "plain", "utf-8")
msg["Subject"] = "自動(dòng)化郵件"
msg["From"] = sender
msg["To"] = "接收人郵箱"

# 發(fā)送
with smtplib.SMTP_SSL(smtp_server, 465) as server:
    server.login(sender, password)
    server.sendmail(sender, msg["To"], msg.as_string())

import os

# 批量重命名文件夾里的所有文件
folder = "文件目錄"
for index, filename in enumerate(os.listdir(folder)):
    old_path = os.path.join(folder, filename)
    new_path = os.path.join(folder, f"文件_{index+1}.xlsx")
    os.rename(old_path, new_path)

# 全自動(dòng)：Excel處理 → 生成報(bào)告 → 發(fā)郵件
import pandas as pd
from docx import Document
import smtplib
# 1. 處理數(shù)據(jù)
df = pd.read_excel("銷售數(shù)據(jù).xlsx")
total = df["銷售額"].sum()
# 2. 生成報(bào)告
doc = Document()
doc.add_heading(f"月度銷售總報(bào)告", 0)
doc.add_paragraph(f"總銷售額：{total} 元")
doc.save("銷售報(bào)告.docx")
# 3. 自動(dòng)發(fā)送郵件
# （把上面的郵件代碼粘貼過來即可）

import pandas as pd

# 讀取 Excel
df = pd.read_excel('input.xlsx', sheet_name='Sheet1')
print(df.head())

# 處理數(shù)據(jù)（例如計(jì)算一列的平均值）
avg = df['銷售額'].mean()

# 寫入新的 Excel
df.to_excel('output.xlsx', index=False)

from openpyxl import load_workbook

wb = load_workbook('template.xlsx')
ws = wb.active

# 讀取單元格
cell_value = ws['A1'].value

# 寫入并設(shè)置格式
ws['B2'] = '已完成'
ws['B2'].font = Font(color='FF0000', bold=True)

wb.save('report.xlsx')

from docx import Document
from docx.shared import Inches

doc = Document()

# 添加標(biāo)題和段落
doc.add_heading('月度報(bào)告', level=0)
doc.add_paragraph('這是自動(dòng)生成的報(bào)告內(nèi)容。')

# 添加表格
table = doc.add_table(rows=3, cols=2)
table.cell(0, 0).text = '項(xiàng)目'
table.cell(0, 1).text = '金額'

# 插入圖片
doc.add_picture('chart.png', width=Inches(5))

doc.save('report.docx')

from docxtpl import DocxTemplate

doc = DocxTemplate('template.docx')
context = {'姓名': '張三', '日期': '2026-06-02'}
doc.render(context)
doc.save('output.docx')

import PyPDF2

merger = PyPDF2.PdfMerger()
for pdf in ['file1.pdf', 'file2.pdf']:
    merger.append(pdf)
merger.write('merged.pdf')
merger.close()

import pdfplumber

with pdfplumber.open('report.pdf') as pdf:
    for page in pdf.pages:
        tables = page.extract_tables()
        for table in tables:
            print(table)

from PyPDF2 import PdfReader, PdfWriter

# 思路：將水印頁疊加到每一頁
watermark = PdfReader('watermark.pdf').pages[0]
writer = PdfWriter()
for page in PdfReader('original.pdf').pages:
    page.merge_page(watermark)
    writer.add_page(page)
with open('watermarked.pdf', 'wb') as f:
    writer.write(f)

import yagmail

yag = yagmail.SMTP('your_email@gmail.com', 'password')
contents = ['正文內(nèi)容', '附件1.xlsx', 'chart.png']
yag.send('to@example.com', '郵件主題', contents)
yag.close()

import pandas as pd
df = pd.read_excel('contacts.xlsx')
for _, row in df.iterrows():
    yag.send(row['郵箱'], '會(huì)議通知', f'{row["姓名"]}，請(qǐng)準(zhǔn)時(shí)參加。')

import os
from pathlib import Path

folder = './files'
for file in Path(folder).glob('*.xlsx'):
    new_name = f"processed_{file.name}"
    file.rename(Path(folder) / new_name)

import shutil
from pathlib import Path

for file in Path('.').iterdir():
    if file.is_file():
        ext = file.suffix[1:]  # 去掉點(diǎn)號(hào)
        target_dir = Path('sorted') / ext
        target_dir.mkdir(parents=True, exist_ok=True)
        shutil.move(str(file), str(target_dir / file.name))

import schedule
import time
def job():
    print("執(zhí)行每日備份...")
    # 調(diào)用備份腳本
schedule.every().day.at("02:00").do(job)
while True:
    schedule.run_pending()
    time.sleep(60)

pip install pyinstaller
pyinstaller --onefile --console automate.py