thepexcel/thepexcelmcp

이 페이지는 AI로 자동 번역되었습니다. 기술적인 세부 사항은 원문을 확인하세요. 원문 보기

16 stars 7 forks 품질 82 트렌드 35MIT

개요

A Windows MCP server that drives a through COM automation. Power Query that actually refreshes, PivotTables that actually pivot, DAX that actually calculates, and screenshots so the AI can see what it built. ThepExcelMCP is a Model Context Protocol server that exposes covering nearly everything a power user can do in Excel — workbooks, ranges, Tables, Power Query (full M-code CRUD), PivotTables, the Data Model with DAX measures, charts, formatting, conditional formats, validation, slicers, page setup / PDF export, protection, VBA (opt-in), and a safety layer with non-destructive snapshots and range/sheet diffing. It is for anyone who works in and wants an AI agent (Claude Code, Claude Desktop, Codex CLI, or any MCP client) to do real spreadsheet work: analysts automating monthly reporting, Excel pros building Power Query pipelines by prompt, and developers who need an agent to build and verify real workbooks.

README

원문 README의 일부입니다. 원문 보기.

What is this?

ThepExcelMCP is a Model Context Protocol server that exposes 26 tools covering nearly everything a power user can do in Excel — workbooks, ranges, Tables, Power Query (full M-code CRUD), PivotTables, the Data Model with DAX measures, charts, formatting, conditional formats, validation, slicers, page setup / PDF export, protection, VBA (opt-in), and a safety layer with non-destructive snapshots and range/sheet diffing.

It is for anyone who works in Excel on Windows and wants an AI agent (Claude Code, Claude Desktop, Codex CLI, or any MCP client) to do real spreadsheet work: analysts automating monthly reporting, Excel pros building Power Query pipelines by prompt, and developers who need an agent to build and verify real workbooks.

When an agent calls a tool here, it is talking to the actual Excel process — including the workbook you already have open. This is the difference between editing an XML zip file and actually using Excel.

Quick start — hand it to your AI agent

Send this GitHub link to your AI coding agent (Claude Code, Codex CLI, …) and tell it to take over — it will read this README and set the MCP server up for you, as either user scope (every project) or project scope (one project only). ❤️

🇹🇭 แค่ส่งลิงก์ GitHub นี้ให้ AI Agent ของคุณ แล้วบอกให้ AI จัดการต่อได้เลย จะลง MCP เป็น User Scope หรือ Project Scope ก็ได้ ❤️

https://github.com/ThepExcel/ThepExcelMCP

Once registered, just talk to your agent. Things you can say:

“Read the table on Sheet1 of Book1 and build a PivotTable of sales by Region, with a chart.”

GitHub에서 전체 README 보기

설치

This server does not publish a one-line install command.

Open the repository installation guide MCP 초보자라면? mcpskill.org 가이드부터 시작하세요 →

설정

{
  "mcpServers": {
    "thepexcel-excel": {
      "command": "uv",
      "args": ["run", "--directory", "C:\\path\\to\\ThepExcelMCP", "python", "-m", "thepexcel_mcp.server"]
    }
  }
}