ExcelForge
ExcelForge �臭�銝芸鈭?MCP (Model Context Protocol) �?Excel ��撌亙��霈?AI �拇��賢�摰����� Excel �辣�?
�?��寞?
- �� *撌乩�蝪輻恣�? - ����摮�?Excel �辣
- �� *撌乩�銵冽�雿? - �遣���賢����文極雿”
- �� �唳霂餃� - 霂餃����亙���唳
- �妙 �砍��舀� - 撉��‵�?Excel �砍�
- � �澆�霈曄蔭 - 摮��器獢‵�笆朣��瑕�
- � 敹怎�� - �唳敹怎銝��砍��
- �� ��摰∟恣 - 摰��雿敹扇敶?
�� 蝟餌�閬�
- ��蝟餌�: Windows嚗�韏?Excel Desktop嚗?- Python: >= 3.11
- Excel: Microsoft Excel Desktop嚗歇摰�撟嗆�瘣鳴�
�� 敹恍�憪?
1. 摰�
# ��隞�
git clone https://github.com/your-username/ExcelForge.git
cd ExcelForge
# �遣���臬�
python -m venv .venv
.venv\Scripts\activate # Windows
# 摰�靘�
pip install -e .
2. �蔭
憭蝷箔��蔭�辣撟嗆�桅�閬耨�對�
cp config.example.yaml config.yaml
*config.yaml �蔭霂湔�嚗?
server:
version: "0.2.0"
actor_id: "local-mcp-client"
excel:
visible: true # Excel 蝒�臬�航�
disable_events: true # 蝳 Excel 鈭辣
disable_alerts: true # 蝳 Excel 霅血�撘寧�
force_disable_macros: true # 撘箏蝳摰?
paths:
allowed_roots: # �捂霈輸�敶���靽格嚗? - "C:/Users/YourName/Documents"
- "D:/Work/Excel"
snapshots_dir: "./.runtime_data/snapshots" # 敹怎摮頝臬�
sqlite_path: "./.runtime_data/excelforge.db" # �唳摨楝敺?
limits:
max_open_workbooks: 8 # �憭扳�撘撌乩�蝪踵
max_read_cells: 10000 # �活�憭扯粉����? max_write_cells: 10000 # �活�憭批��亙���? operation_timeout_seconds: 30 # ��頞�園
snapshot:
max_per_workbook: 50 # 瘥葵撌乩�蝪踵�憭批翰�扳
max_total_size_mb: 200 # 敹怎�餃之撠��? max_age_hours: 24 # 敹怎餈��園
3. �?AI 摰Ｘ蝡臭葉�蔭
Claude Desktop
蝻� Claude �蔭�辣嚗indows: %APPDATA%\Claude\claude_desktop_config.json嚗�
{
"mcpServers": {
"excelforge": {
"command": "uv",
"args": ["run", "python", "-m", "excelforge", "--config", "config.yaml", "serve"],
"cwd": "C:/path/to/ExcelForge"
}
}
}
VS Code (Trae / Kiro)
�券★�?.kiro/settings/mcp.json 銝剝�蝵殷�
{
"mcpServers": {
"excelforge": {
"command": "uv",
"args": ["run", "python", "-m", "excelforge", "--config", "config.yaml", "serve"],
"cwd": "${workspaceFolder}"
}
}
}
4. �臬�
# �湔�臬 MCP �
python -m excelforge --config config.yaml serve
��儭?MCP 撌亙�”
撌乩�蝪踵�雿?
| 撌亙�妍 | ��膩 |
|---|---|
workbook.open_file | �� Excel �辣 |
workbook.save_file | 靽�撌乩�蝪? |
workbook.close_file | �喲撌乩�蝪? |
workbook.create_file | �遣�啣極雿倏 |
workbook.get_info | �瑕�撌乩�蝪蹂縑�? |
workbook.list_open | �撌脫�撘�極雿倏 |
撌乩�銵冽�雿?
| 撌亙�妍 | ��膩 |
|---|---|
sheet.create_sheet | �遣�啣極雿” |
sheet.rename_sheet | ��極雿” |
sheet.inspect_structure | 璉�亙極雿”蝏� |
�唳��
| 撌亙�妍 | ��膩 |
|---|---|
range.read_values | 霂餃����潭�? |
range.write_values | ����潭�? |
range.clear_contents | 皜���澆�摰? |
range.copy_range | 憭���澆�? |
�砍���
| 撌亙�妍 | ��膩 |
|---|---|
formula.validate_expression | 撉��砍�銵刻噢撘? |
formula.fill_range | �典�‵�撘? |
�澆�霈曄蔭
| 撌亙�妍 | ��膩 |
|---|---|
format.set_range_style | 霈曄蔭���潭撘�摮��器獢‵�笆朣� |
format.auto_fit_columns | �芸靚�捐 |
敹怎銝�皛?
| 撌亙�妍 | ��膩 |
|---|---|
snapshot.get_stats | �瑕�敹怎蝏恣 |
snapshot.run_cleanup | 皜�餈�敹怎 |
rollback.list_snapshots | ��舐敹怎 |
rollback.preview_snapshot | 憸�敹怎撌桀� |
rollback.restore_snapshot | �Ｗ��啣翰�抒��? |
摰∟恣�亙�
| 撌亙�妍 | ��膩 |
|---|---|
audit.list_operations | �亥砭���亙� |
�� 雿輻蝷箔�
���辣撟嗉粉��?
�冽: �� D:/Work/data.xlsx �辣嚗粉�?Sheet1 �?A1:D10 �箏�
��唳撟嗉挽蝵格撘?
�冽: �?Sheet1 �?A1 ���澆��?��桅�"嚗挽蝵桀�雿�蝎��航銝箄��?```
### �遣敹怎隞乩噶��
�冽: �其耨�寞�桀��遣銝銝芸翰�?�冽: 憒��粹�鈭��Ｗ��唬���敹怎
## �� 憿寧蝏�
ExcelForge/ ��� excelforge/ # �詨�隞�� �? ��� models/ # �唳璅∪� �? ��� services/ # 銝� �? ��� tools/ # MCP 撌亙摰� �? ��� persistence/ # �唳���?�? ��� runtime/ # Excel 餈��?�? ��� utils/ # 撌亙�賣 ��� tests/ # 瘚��辣 ��� config.yaml # �蔭�辣嚗��芾��遣嚗?��� config.example.yaml # �蔭蝷箔� ��� pyproject.toml # 憿寧�蔭 ��� README.md # �祆�隞?```
�� 摰霂湔�
- 頝臬��: �芾霈輸
allowed_roots�蔭�敶?- ��摰∟恣: ���雿�敹扇敶?- 敹怎靽: ������典�撱箏翰�改��舀��� - **摰��?*: 暺恕蝳 Excel 摰��脫迫�嗆�隞���扯�
�� 撘皞捂�航�
�祇★�桅��?MIT License 撘皞�霈柴?
���
�典隞亥�勗嚗?- �?��雿輻 - 撠蔓隞嗥鈭�銝�?- �?靽格 - 靽格頧臭辣皞誨�?- �?�� - ��頧臭辣�舀
- �?蝘犖雿輻 - 蝘犖雿輻頧臭辣
�∩辣
- �� 靽���憯唳� - 敹◆�刻蔓隞嗅�砌葉�����憯唳��捂�航�
- �� 憯唳�� - 靽格�辣��憯唳�撌脫�?
�提憯唳�
�祈蔓隞嗆�"�"��嚗���隞颱��內��蝷箇�靽�嚗��砌�銝�鈭��批���找�霂���撖嫣遙雿揣韏�摰單��嗡�韐�遙韐提�? 霂西� LICENSE �辣�?
�� 韐∠��
甈Ｚ��漱 Issue �?Pull Request嚗?
- Fork �砌�摨?2. �遣�� (
git checkout -b feature/AmazingFeature) - �漱�湔 (
git commit -m 'Add some AmazingFeature') - �券� (
git push origin feature/AmazingFeature) - �遣 Pull Request
� �頂�孵�
憒��桅��遣霈殷�霂瑟�鈭?Issue�?
ExcelForge - 霈?AI �蛹�函� Excel �拇� ��