Python 20个高效实用的自动化办公库，效率提升5倍起步

from docx import Document

doc = Document()
doc.add_heading('年度总结', level=1)
doc.add_paragraph('这是自动生成的报告内容')
doc.save('report.docx')

from openpyxl import load_workbook

wb = load_workbook('data.xlsx')
ws = wb.active
ws['A1'] = "销量"
ws['B1'] = 100
wb.save('data.xlsx')

from PyPDF2 import PdfMerger

merger = PdfMerger()
merger.append("file1.pdf")
merger.append("file2.pdf")
merger.write("merged.pdf")

from pptx import Presentation

prs = Presentation()
slide = prs.slides.add_slide(prs.slide_layouts[0])
slide.shapes.title.text = "项目汇报"
prs.save('presentation.pptx')

from PIL import Image

img = Image.open('photo.jpg')
img = img.resize((800, 600))
img.save('resized.jpg')

import shutil
import os

shutil.copy('source.txt', 'backup/')
os.makedirs('new_folder', exist_ok=True)

import pyautogui

pyautogui.click(100, 200)
pyautogui.typewrite('hello')

import schedule

def job():
    print("执行定时任务")

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

from watchdog.observers import Observer
from watchdog.events import FileSystemEventHandler

class Handler(FileSystemEventHandler):
    def on_modified(self, event):
        print(f"文件被修改: {event.src_path}")

import psutil

cpu_percent = psutil.cpu_percent()
memory_info = psutil.virtual_memory()
print(f"CPU使用率: {cpu_percent}%")

import pandas as pd

df = pd.read_excel('sales.xlsx')
result = df.groupby('产品').sum()
result.to_excel('summary.xlsx')

import xlwings as xw

wb = xw.Book('model.xlsx')
wb.sheets['Sheet1'].range('A1').value = "更新数据"

import numpy as np

arr = np.array([1, 2, 3])
arr2d = np.array([[1, 2], [3, 4]])

from openpyxl import Workbook

wb = Workbook()
ws = wb.active
ws['A1'] = "姓名"
ws['B1'] = "分数"
wb.save('grades.xlsx')

import matplotlib.pyplot as plt

plt.plot([1, 2, 3], [4, 5, 6])
plt.title("销售趋势")
plt.savefig('chart.png')

import smtplib
from email.mime.text import MIMEText

msg = MIMEText("邮件正文")
msg['Subject'] = "自动报表"
server.sendmail(from_addr, to_addr, msg.as_string())

import requests

response = requests.get('https://api.example.com/data')
data = response.json()

from selenium import webdriver

driver = webdriver.Chrome()
driver.get("https://login.page")
driver.find_element_by_id("username").send_keys("user")

from bs4 import BeautifulSoup

soup = BeautifulSoup(html_content, 'html.parser')
title = soup.find('h1').text

import office

office.pdf.pdf2docx(file_path='input.pdf')