office-automation▌
texiaoyao/office-automation-skill · updated Apr 8, 2026
MDX-style export adds YAML metadata + attribution linking explainx.ai and this canonical listing URL.
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 w
Office 自动化技能
使用 Python 脚本自动化处理 Word (.docx) 和 Excel (.xlsx/xlsm) 文件。
快速开始
1. 安装依赖
pip install python-docx openpyxl pandas
2. 基本用法
处理 Word 文档:
python scripts/word_processor.py read document.docx
python scripts/word_processor.py write output.docx --content "Hello World"
python scripts/word_processor.py template fill.docx --data '{"name": "张三", "date": "2026-02-22"}'
处理 Excel 表格:
python scripts/excel_processor.py read data.xlsx
python scripts/excel_processor.py write output.xlsx --sheet "Sheet1"
python scripts/excel_processor.py merge folder/ --output merged.xlsx
脚本说明
word_processor.py
| 命令 | 说明 | 示例 |
|---|---|---|
read |
读取 Word 文档内容 | read file.docx |
write |
创建新文档 | write out.docx --content "文本" |
template |
填充模板(替换 {{变量}}) | template doc.docx --data '{"key": "value"}' |
extract |
提取表格到 CSV | extract file.docx --table 1 |
format |
格式化文档 | format file.docx --style heading |
excel_processor.py
| 命令 | 说明 | 示例 |
|---|---|---|
read |
读取 Excel 数据 | read data.xlsx --sheet Sheet1 |
write |
写入数据到 Excel | write out.xlsx --data data.json |
merge |
合并多个 Excel 文件 | merge folder/ --output all.xlsx |
convert |
Excel ↔ CSV 转换 | convert file.xlsx --to csv |
analyze |
数据分析(统计、透视) | analyze sales.xlsx --pivot |
使用场景
Word 处理
- 📝 批量生成报告/合同
- 📋 填充模板文档
- 📊 提取文档中的表格数据
- 🎨 统一文档格式
Excel 处理
- 📈 数据汇总和合并
- 🔄 格式转换(Excel ↔ CSV)
- 📊 数据分析和统计
- 📋 批量处理多个表格
注意事项
- Word 格式:仅支持 .docx 格式(不支持旧版 .doc)
- Excel 格式:支持 .xlsx 和 .xlsm
- 编码:默认使用 UTF-8 编码
- 大文件:超过 100MB 的文件建议分批次处理
脚本位置
所有脚本位于 skills/office-automation/scripts/ 目录。
使用时请确保从技能目录或 workspace 根目录运行。
How to use office-automation on Cursor
AI-first code editor with Composer
Prerequisites
Before installing skills in Cursor, ensure your development environment meets these requirements:
- ›Cursor installed and configured on your development machine
- ›Node.js version 16.0+ with npm package manager (verify with
node --version) - ›Active project directory or workspace where you want to add office-automation
Execute installation command
Execute the skills CLI command in your project's root directory to begin installation:
The skills CLI fetches office-automation from GitHub repository texiaoyao/office-automation-skill and configures it for Cursor.
Select Cursor when prompted
The CLI will show a list of available agents. Use arrow keys to navigate and space to select Cursor:
Verify installation
Confirm successful installation by checking the skill directory location:
Reload or restart Cursor to activate office-automation. Access the skill through slash commands (e.g., /office-automation) or your agent's skill management interface.
Security & Verification Notice
We perform automated surface-level scans (Gen AI Scanner, Socket, Snyk) during installation. These checks detect common vulnerabilities but do not guarantee complete security. Always review skill source code and verify the publisher's reputation before production use.
Skills execute code in your development environment. Always verify the publisher's identity, review recent commits, and test in isolated environments before production deployment.
List & Monetize Your Skill
Submit your Claude Code skill and start earning
Use Cases▌
Task Automation & Efficiency
Automate repetitive workflows and reduce manual effort
Example
Generate reports, summarize documents, draft communications
Save 3-5 hours per week on routine tasks
Knowledge Enhancement
Learn new skills, understand complex topics, get expert guidance
Example
Explain concepts, provide examples, suggest learning resources
Accelerate learning and skill development by 2x
Quality Improvement
Enhance output quality through reviews, suggestions, and refinements
Example
Review drafts, suggest improvements, catch errors
Improve work quality by 30-40% with less effort
Implementation Guide▌
Prerequisites
- ›Claude Desktop or compatible AI client with skill support
- ›Clear understanding of task or problem to solve
- ›Willingness to iterate and refine outputs
Time Estimate
15-45 minutes depending on use case complexity
Installation Steps
- 1.Install skill using provided installation command
- 2.Test with simple use case relevant to your work
- 3.Evaluate output quality and relevance
- 4.Iterate on prompts to improve results
- 5.Integrate into regular workflow if valuable
Common Pitfalls
- ⚠Expecting perfect results without iteration
- ⚠Not providing enough context in prompts
- ⚠Using skill for tasks outside its intended scope
- ⚠Accepting outputs without review and validation
Best Practices▌
✓ Do
- +Start with clear, specific prompts
- +Provide relevant context and constraints
- +Review and refine all outputs before using
- +Iterate to improve output quality
- +Document successful prompt patterns
✗ Don't
- −Don't use without understanding skill limitations
- −Don't skip validation of outputs
- −Don't share sensitive information in prompts
- −Don't expect skill to replace human judgment
💡 Pro Tips
- ★Be specific about desired format and style
- ★Ask for multiple options to choose from
- ★Request explanations to understand reasoning
- ★Combine AI efficiency with human expertise
When to Use This▌
✓ Use When
Use when skill capabilities match your task, clear ROI on time saved, and you can validate outputs. Best for repetitive tasks, learning, and quality improvement.
✗ Avoid When
Avoid when task requires deep expertise you can't validate, involves sensitive decisions, or when learning process is more valuable than speed of completion.
Learning Path▌
- 1Familiarize yourself with skill capabilities and limitations
- 2Start with low-risk, non-critical tasks
- 3Progress to more complex and valuable use cases
- 4Build expertise through regular use and experimentation
Discussion
Product Hunt–style comments (not star reviews)- No comments yet — start the thread.
Ratings
4.6★★★★★46 reviews- ★★★★★Soo Iyer· Dec 24, 2024
Solid pick for teams standardizing on skills: office-automation is focused, and the summary matches what you get after install.
- ★★★★★Zara Patel· Dec 16, 2024
office-automation is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.
- ★★★★★Amelia Martinez· Dec 12, 2024
Registry listing for office-automation matched our evaluation — installs cleanly and behaves as described in the markdown.
- ★★★★★Daniel Sethi· Nov 15, 2024
We added office-automation from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.
- ★★★★★Charlotte Diallo· Nov 7, 2024
office-automation reduced setup friction for our internal harness; good balance of opinion and flexibility.
- ★★★★★Alexander Bansal· Nov 3, 2024
Keeps context tight: office-automation is the kind of skill you can hand to a new teammate without a long onboarding doc.
- ★★★★★Alexander Bhatia· Oct 26, 2024
Registry listing for office-automation matched our evaluation — installs cleanly and behaves as described in the markdown.
- ★★★★★Hana Sanchez· Oct 22, 2024
office-automation is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.
- ★★★★★Daniel Taylor· Oct 6, 2024
office-automation fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.
- ★★★★★Rahul Santra· Sep 17, 2024
I recommend office-automation for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
showing 1-10 of 46