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.

$npx skills add https://github.com/texiaoyao/office-automation-skill --skill office-automation
0 commentsdiscussion
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 w
skill.md

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)
  • 📊 数据分析和统计
  • 📋 批量处理多个表格

注意事项

  1. Word 格式:仅支持 .docx 格式(不支持旧版 .doc)
  2. Excel 格式:支持 .xlsx 和 .xlsm
  3. 编码:默认使用 UTF-8 编码
  4. 大文件:超过 100MB 的文件建议分批次处理

脚本位置

所有脚本位于 skills/office-automation/scripts/ 目录。

使用时请确保从技能目录或 workspace 根目录运行。

how to use office-automation

How to use office-automation on Cursor

AI-first code editor with Composer

1

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
2

Execute installation command

Execute the skills CLI command in your project's root directory to begin installation:

$npx skills add https://github.com/texiaoyao/office-automation-skill --skill office-automation

The skills CLI fetches office-automation from GitHub repository texiaoyao/office-automation-skill and configures it for Cursor.

3

Select Cursor when prompted

The CLI will show a list of available agents. Use arrow keys to navigate and space to select Cursor:

◆ Which agents do you want to install to?
│ ── Universal (.agents/skills) ── always included ────
│ • Amp
│ • Antigravity
│ • Cline
│ • Codex
│ ●Cursor(selected)
│ • Cursor
│ • Windsurf
4

Verify installation

Confirm successful installation by checking the skill directory location:

.cursor/skills/office-automation

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

GET_STARTED →

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. 1.Install skill using provided installation command
  2. 2.Test with simple use case relevant to your work
  3. 3.Evaluate output quality and relevance
  4. 4.Iterate on prompts to improve results
  5. 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

  1. 1Familiarize yourself with skill capabilities and limitations
  2. 2Start with low-risk, non-critical tasks
  3. 3Progress to more complex and valuable use cases
  4. 4Build expertise through regular use and experimentation

Discussion

Product Hunt–style comments (not star reviews)
  • No comments yet — start the thread.
general reviews

Ratings

4.646 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

1 / 5