Python 25个高效实用的自动化办公库，提升效率

from docx import Document
doc = Document()
doc.add_heading('年度总结', level=1)
doc.save('report.docx')

from openpyxl import load_workbook
wb = load_workbook('data.xlsx')
ws = wb.active
ws['A1'] = "销量"

from PyPDF2 import PdfMerger
merger = PdfMerger()
merger.append("file1.pdf")
merger.write("merged.pdf")

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

import pdfplumber
with pdfplumber.open("invoice.pdf") as pdf:
    page = pdf.pages[0]
    table = page.extract_table()

import shutil, os
shutil.copy('source.txt', 'backup/')

import pyautogui
pyautogui.click(100, 200)

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

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

from apscheduler.schedulers.background import BackgroundScheduler
scheduler = BackgroundScheduler()
scheduler.add_job(send_report, 'cron', hour=9)

import pandas as pd
df = pd.read_excel('sales.xlsx')
df.groupby('产品').sum().plot.bar()

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.styles import Font
cell.font = Font(bold=True, color="FF0000")

import pyxlsb
workbook = pyxlsb.open_workbook('large_data.xlsb')

import smtplib
msg = MIMEMultipart()
msg.attach(MIMEText("正文内容"))
server.sendmail(from_addr, to_addr, msg.as_string())

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

from selenium import webdriver
driver = webdriver.Chrome()
driver.get("https://login.page")

from bs4 import BeautifulSoup
soup = BeautifulSoup(html, 'html.parser')
title = soup.find('h1').text

import aiohttp
import asyncio
async def fetch(session, url):
    async with session.get(url) as response:
        return await response.text()

from tqdm import tqdm
for i in tqdm(range(10000)):
    process_data(i)

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

import pyperclip
pyperclip.copy("要复制的内容")
text = pyperclip.paste()

from rich.console import Console
console = Console()
console.print("Hello", style="bold red")

from loguru import logger
logger.add("file.log", rotation="500 MB")
logger.info("任务开始执行")