ExcelMCP

ExcelMCP

1

ExcelMCP is a server for automating Microsoft Excel tasks via AI models on Windows OS. It enables control of Excel applications and execution of Python code, enhancing efficiency and automating tasks. It is not compatible with Linux or MacOS.

ExcelMCP

ExcelMCP server automates the Microsoft Excel Application on Windows OS using AI models. It offers two modes of installation: stdio and sse server. The server allows AI models to control Excel, including opening new applications, checking installation status, launching and quitting applications, and operating workbooks. There are several tools provided for operating Excel and an option to run Python code within the Excel application for extended functionality. The project is not compatible with Linux/MacOS systems.

Usage

  • Request AI model to open or operate an Excel application
  • AI model sends requests to the ExcelMCP server to execute commands

Tools Reference

  • Installed() verifies installation
  • Launch(...) starts an application
  • Visible() toggles visibility
  • Quit() exits the application
  • WorkBook(...) manages workbooks
  • RunPython(...) executes Python code within Excel using openpyxl library