office-automation

texiaoyao/office-automation-skill

Automate Word and Excel file processing with Python scripts for batch operations, template filling, and data extraction.

Source View on skills.sh

What is office-automation?

This skill automates reading, writing, and formatting Word (.docx) and Excel (.xlsx/.xlsm) files using Python. Use it for batch document generation, template population, data extraction, and format conversion tasks.

Read and write Word documents (.docx) with content manipulation
Read, write, and merge Excel spreadsheets with sheet management
Fill document templates by replacing variables with provided data
Extract tables from Word documents to CSV format
Convert between Excel and CSV formats
Perform data analysis and pivot operations on spreadsheets

How to install office-automation

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

Prerequisites

Python 3 installed
pip packages: python-docx, openpyxl, pandas

Claude Code

Cursor

Windsurf

Cline

How to use office-automation

1.Install dependencies with: pip install python-docx openpyxl pandas
2.For Word files, use python scripts/word_processor.py with commands: read, write, template, extract, or format
3.For Excel files, use python scripts/excel_processor.py with commands: read, write, merge, convert, or analyze
4.Provide data as JSON for template filling or as file paths for batch operations
5.Run scripts from the skill directory or workspace root

Use cases

Good for

Batch generate reports or contracts from templates
Merge multiple Excel files into a single consolidated spreadsheet
Extract tabular data from Word documents for further processing
Convert Excel data to CSV for import into other systems
Apply consistent formatting across multiple documents

Who it's for

Data analysts processing multiple spreadsheets
Business users automating report generation
Document processors handling template-based workflows
Teams managing bulk data conversions
Administrative staff automating routine document tasks

office-automation FAQ

What file formats are supported?

Word: .docx format only (legacy .doc not supported). Excel: .xlsx and .xlsm formats.

How do I fill a template document?

Use the template command with JSON data: python scripts/word_processor.py template doc.docx --data '{"name": "value"}'

Can I merge multiple Excel files?

Yes, use the merge command: python scripts/excel_processor.py merge folder/ --output merged.xlsx

What encoding is used?

UTF-8 encoding by default.

Are there limitations for large files?

Files over 100MB should be processed in batches for optimal performance.

Full instructions (SKILL.md)

Source of truth, from texiaoyao/office-automation-skill.

name: office-automation description: 自动化处理 Word 和 Excel 文件。使用 Python 脚本读取、写入、格式化文档和表格。支持批量处理、模板填充、数据提取和格式转换。 metadata: { "openclaw": { "emoji": "📊", "requires": { "bins": ["python3"], "python_packages": ["python-docx", "openpyxl", "pandas"] }, "install": [ { "id": "office-deps", "kind": "pip", "packages": ["python-docx", "openpyxl", "pandas"], "label": "安装 Office 处理依赖 (pip)", }, ], }, }

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`