office-automation
12
总安装量
12
周安装量
#26422
全站排名
安装命令
npx skills add https://github.com/texiaoyao/office-automation-skill --skill office-automation
Agent 安装分布
gemini-cli
12
github-copilot
12
codex
12
kimi-cli
12
amp
12
cline
12
Skill 文档
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 æ ¹ç®å½è¿è¡ã