中文 · 中文文档 · English

python-office

🚀 Office automation, one line of code at a time
73 ready-to-use Skills covering PDF, Word, Excel, PPT, Email, WeChat, Images, Video and more

⚡ TL;DR

python-office is the most popular Python office-automation library in the Chinese-speaking world. One library covers 90% of office scenarios: PDF / Word / Excel / PPT conversion, image processing, video & audio, WeChat bot, email, file management, OCR, AI tools... Zero Python knowledge required — every feature is one line of code.

pip install python-office

import office  # one import, all features available

✨ Key Features

📸 Demo

🚧 Showcase area — replace these with your own screenshots or GIFs

Image Processing	PDF Processing	WeChat Bot
Watermark / Word cloud / Sketch	Convert / Merge / Encrypt	Broadcast / Smart chat

Excel Processing	PPT Processing	Video / Audio
Mock data / Merge / Split	Convert / Snapshot	Extract audio / Subtitle

🧭 Quick Navigation

🧩 Skills system (73 ready-to-use Skills)

python-office ships with a built-in Skill system: the library's 73 methods are wrapped as 73 independently importable Skills, each with its own SKILL.md documentation.

💡 Why Skills? Skills let Codex, Claude, Cursor and other AI tools automatically recognize your request and call the right function.

# Option 1: Import a specific Skill
from skills.image import compress_image
compress_image(input_file='photo.jpg', output_file='photo_small.jpg', quality=30)

# Option 2: Import by category
from skills.pdf import pdf2docx
pdf2docx(input_file='report.pdf', output_file='report.docx')

# Option 3: Original office style (still works)
import office
office.image.compress_image(input_file='photo.jpg', output_file='photo_small.jpg', quality=30)

📋 13 Categories at a Glance

👉 Full index: skills/README.md

📦 Installation

# Install everything (recommended)
pip install -i https://mirrors.aliyun.com/pypi/simple/ python-office -U

# Install only what you need (lighter)
pip install popdf      # PDF processing only
pip install poimage    # Image processing only
pip install poword     # Word processing only
pip install poexcel    # Excel processing only

Python version: Python 3.7+ Install issues? 📝 Troubleshooting

💻 CLI: the po command

Installing python-office also gives you a terminal command — no Python code needed:

po pdf merge2pdf a.pdf b.pdf --output-file merged.pdf
po excel excel2pdf report.xlsx report.pdf
po tools url2ip www.python-office.com

po --json tools url2ip www.python-office.com   # one-line JSON for scripts & agents

po --help lists all modules and commands (python -m office works as an alias).

🚀 Quick Start

# 1. PDF → Word
from skills.pdf import pdf2docx
pdf2docx(input_file='report.pdf', output_file='report.docx')

# 2. Compress an image
from skills.image import compress_image
compress_image(input_file='big.jpg', output_file='small.jpg', quality=30)

# 3. Add a watermark to an image
from skills.image import add_watermark
add_watermark(file='photo.jpg', mark='@python-office')

# 4. Generate a word cloud
from skills.image import txt2wordcloud
txt2wordcloud(filename='article.txt', result_file='wordcloud.png')

# 5. Generate a QR code
from skills.tools import qrcodetools
qrcodetools(url='https://www.python-office.com', output='qrcode.png')

🎬 Video tutorials: https://www.python-office.com/video/video.html

💡 Featured Skills

from skills.excel import fake2excel
fake2excel(columns=['name', 'phone'], rows=1000, path='test.xlsx')

from skills.excel import merge2excel
merge2excel(dir_path='./my_excels', output_file='all.xlsx')

from skills.pdf import pdf2docx       # PDF → Word
from skills.pdf import pdf2imgs        # PDF → images
from skills.pdf import merge2pdf       # Merge multiple PDFs
from skills.pdf import split4pdf       # Split a PDF
from skills.pdf import encrypt4pdf     # Encrypt a PDF
from skills.pdf import add_watermark_by_parameters  # PDF watermark

from skills.image import compress_image       # Compress images
from skills.image import add_watermark        # Add watermark
from skills.image import del_watermark        # Remove watermark
from skills.image import txt2wordcloud        # Generate word cloud
from skills.image import pencil4img           # Pencil-sketch style
from skills.image import img2Cartoon          # Cartoon style
from skills.image import decode_qrcode        # Decode QR code

from skills.wechat import send_message
send_message(who='File Transfer', message='Hello!')

from skills.wechat import send_message_by_time
send_message_by_time(who='File Transfer', message='Good morning', time='08:00:00')

from skills.video import video2mp3       # Video → MP3
from skills.video import audio2txt       # Audio → text
from skills.video import txt2mp3         # Text → speech
from skills.video import mark2video      # Video watermark

🌟 Use Cases

python-office fits the following roles and scenarios:

🛠️ Components

Each feature is accessible via the traditional import office style, or directly from skills.xxx.

🗺️ Roadmap

• v1.x: 73 Skills covering all office automation scenarios
• Skills system: Every feature independently AI-callable
• v2.0: Plugin architecture with custom Skill support
• Web GUI: Visual operation interface
• More AI capabilities: AI writing, AI data analysis
• Enterprise edition: Private deployment + permission management

Feel free to submit requests in Issues!

📝 Documentation

• 📘 Chinese Documentation
• 📗 English Documentation
• 🎬 Video Tutorials
• 🤖 Skills Index
• ❓ FAQ

🤝 Contributing

Contributions are welcome. Please submit your PR in a dedicated folder:

• Create a folder with your GitHub username under contributors
• Put all your code inside that folder
• Do not modify any other folders
• For questions about existing code, please open an issue

Code Style

1. Comments: Document every parameter and return value of new functions
2. Formatting: Format only your own code
3. Tests: Unit tests are optional but strongly recommended
4. Skills: When adding a new method, also add a Skill wrapper under skills/<category>/<method>/

Contributors ✨

Thanks to everyone who makes python-office better!

🐞 Bug Reports & Suggestions

Please only submit issues related to the python-office codebase itself. We don't answer general Python learning questions.

• GitHub Issues
• Gitee Issues
• AtomGit Issues

💖 Sponsor

If python-office has saved you significant time, please consider supporting continued development:

• ⭐ Star this repo — the biggest support
• 🗣️ Tell your friends — word of mouth
• 💰 WeChat tip — see the QR code at the bottom of this README
• 🐛 Contribute code — submit a PR or Issue

📜 License

This project is licensed under the MIT License.

MIT License

Copyright (c) 2026 CoderWanFeng

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

🙏 Acknowledgments

• Thanks to all contributors and issue reporters
• Thanks to the python4office community
• Inspired by outstanding open-source projects like Requests, FastAPI, LangChain
• Built with ❤️ in China

⭐ Star History

📌 Contact the Author

👉 Join the open-source community · WeChat the author 👈

_{If this project helps you, a ⭐ Star is the best encouragement!}