office-automation

Automate Word and Excel file processing with Python scripts for reading, writing, formatting, and batch operations.

Works with

Claude CodeCursorClineWindsurfCodexGooseGitHub CopilotZed

0

total installs

0

this week

4

GitHub stars

0

upvotes

Install Skill

Run in your terminal

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

0

installs

0

this week

4

stars

What it does

  • 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

Category

Documents

Last updated

Apr 8, 2026

Installation Guide

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 machine
  • Node.js 16+ with npm — verify with node --version
  • Active project directory where you want to add office-automation
2

Run the install 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

Fetches office-automation from texiaoyao/office-automation-skill and configures it for Cursor.

3

Select Cursor when prompted

The CLI shows a list of agents. Use arrow keys and space to select Cursor:

◆ Which agents do you want to install to?
│ ── Universal (.agents/skills) ────────────────
│ · Cline · Codex · Goose · Windsurf
│ ●Cursor(selected)
│ · Cursor · Aider · Continue
4

Verify installation

Confirm successful installation by checking the skill directory location:

.cursor/skills/office-automation

Restart Cursor to activate office-automation. Access via /office-automation in your agent's command palette.

Security 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 environment. Always review source, verify the publisher, and test in isolation before production.

Documentation

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 根目录运行。

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

Steps

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

Related Skills

Reviews

4.646 reviews
  • S
    Soo IyerDec 24, 2024

    Solid pick for teams standardizing on skills: office-automation is focused, and the summary matches what you get after install.

  • Z
    Zara PatelDec 16, 2024

    office-automation is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.

  • A
    Amelia MartinezDec 12, 2024

    Registry listing for office-automation matched our evaluation — installs cleanly and behaves as described in the markdown.

  • D
    Daniel SethiNov 15, 2024

    We added office-automation from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.

  • C
    Charlotte DialloNov 7, 2024

    office-automation reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • A
    Alexander BansalNov 3, 2024

    Keeps context tight: office-automation is the kind of skill you can hand to a new teammate without a long onboarding doc.

  • A
    Alexander BhatiaOct 26, 2024

    Registry listing for office-automation matched our evaluation — installs cleanly and behaves as described in the markdown.

  • H
    Hana SanchezOct 22, 2024

    office-automation is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.

  • D
    Daniel TaylorOct 6, 2024

    office-automation fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.

  • R
    Rahul SantraSep 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

Discussion

Comments — not star reviews
  • No comments yet — start the thread.