Skip to content

derek2000139/Excel_MCP

Repository files navigation

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 摰X蝡臭葉�蔭

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 �W��啣翰�抒��?

摰∟恣�亙�

撌亙�妍 ��膩
audit.list_operations �亥砭���亙�

�� 雿輻蝷箔�

���辣撟嗉粉��?

�冽: �� D:/Work/data.xlsx �辣嚗粉�?Sheet1 �?A1:D10 �箏�

��唳撟嗉挽蝵格撘?

�冽: �?Sheet1 �?A1 ���澆��?���桅�"嚗挽蝵桀�雿�蝎���航銝箄��?```

### �遣敹怎隞乩噶��

�冽: �其耨�寞�桀��遣銝�銝芸翰�?�冽: 憒��粹�鈭��W��唬���敹怎


## �� 憿寧蝏�

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 �辣�?

�� 韐∠��

甈Z��漱 Issue �?Pull Request嚗?

  1. Fork �砌�摨?2. �遣�� (git checkout -b feature/AmazingFeature)
  2. �漱�湔 (git commit -m 'Add some AmazingFeature')
  3. �券�� (git push origin feature/AmazingFeature)
  4. �遣 Pull Request

� �頂�孵�

憒��桅��遣霈殷�霂瑟�鈭?Issue�?

ExcelForge - 霈?AI �蛹�函� Excel �拇� ��

About

基于 MCP 协议的开源服务器工具,支持 Excel 全操作,提供数据处理、公式、格式、图表、透视表功能,集成灵活,适配各类系统模型,适用于自动化办公与数据服务。 Open-source server tool based on Model Context Protocol (MCP). Supports full Excel operations, with data processing, formulas, formatting, charts, pivot tables. Flexible integration for systems & models, ideal for office automation and data services.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages