Excel Bridge

🚀 mcp-excel-server

The mcp-excel-server is a project developed based on the Spring AI MCP framework. Its main function is to provide large language models (LLMs) with the ability to read and write local Excel files through the MCP protocol. This project enables AI to call local tools like humans, breaking the limitations of static knowledge bases and achieving dynamic interaction.

🚀 Quick Start

The mcp-excel-server is designed to empower large language models with the capability to interact with local Excel files. This section will guide you through the installation and configuration process to get the server up and running.

✨ Features

• Excel File Reading: It can read local Excel files (supporting .xlsx and .xls formats) and return the content in JSON format.
• Excel File Writing: It can write JSON data into specified local Excel files.
• Integration with LLM: It can be integrated with LLM clients that support the MCP protocol, such as Claude, Cursor, and Cherry Studio.

📦 Installation

Environment Requirements

Java 17 or higher

Steps

Step 1: Package the project Execute the following command to package the project:

mvn clean package -Dmaven.test.skip=true

Step 2: Configure MCP Server

{
  "mcpServers": {
    "AUM5itYnoMcxPiU2vFa3Z": {
      "name": "Excel Operation",
      "type": "stdio",
      "description": "",
      "isActive": true,
      "command": "java",
      "args": [
        "-Dspring.ai.mcp.server.stdio=true",
        "-Dspring.main.web-application-type=none",
        "-Dfile.encoding=UTF-8",
        "-jar",
        "{your_path}/mcp-excel-server-0.0.1-SNAPSHOT.jar"
      ]
    }
  }
}

💻 Usage Examples

Function Demonstration

order.xlsx: Generated result: