office-automation
Installation
Summary
Automate Word and Excel file processing with Python scripts for reading, writing, formatting, and batch operations.
- Supports Word (.docx) and Excel (.xlsx, .xlsm) files with commands for reading, writing, template filling, table extraction, and format conversion
- Includes batch merge capabilities, data analysis with pivot tables, Excel-to-CSV conversion, and document formatting
- Template system enables variable substitution ({{key}} syntax) for bulk document generation and mail-merge workflows
- Requires python-docx, openpyxl, and pandas; handles UTF-8 encoding and recommends splitting files over 100MB
SKILL.md
Office 自动化技能
使用 Python 脚本自动化处理 Word (.docx) 和 Excel (.xlsx/xlsm) 文件。
快速开始
1. 安装依赖
pip install python-docx openpyxl pandas