excel

This MCP server hosts an Excel-processing service over SSE (Server-Sent Events). It is packaged as a Java-based server that you deploy on a server, requiring OpenJDK 17. After extracting the distribution you configure the server in the conf directory (particularly the server.port and the Spring MCP settings). Once started, the server exposes an SSE endpoint at ip:port/sse/mcp where you can subscribe to updates and issue MCP-style commands. The server provides tools to upload Excel files, read Excel contents, generate new Excel files from 2D data, obtain a download link for created files, and modify the workbook by adding rows, adding columns, or updating cell values. Use the provided endpoints and capabilities to integrate Excel operations into your MCP workflow.

Prerequisites:

• Java 17 (OpenJDK 17)
• tar utility to extract the distribution

Install steps:

1. Transfer the excel-mcp-server-0.1.0.tar.gz archive to your server.

2. Extract the package: tar -xvf excel-mcp-server-0.1.0.tar.gz

3. Edit the configuration file under conf to set server port and the Excel storage/download settings. Example from the README: server: port: 9453 spring: ai: mcp: server: name: Excel Mcp Server version: 0.1.0 type: ASYNC sse-endpoint: /sse sse-message-endpoint: /mcp capabilities: tool: true resource: true prompt: true completion: true

   excel: savePath: /Users/zhongyangyang/Desktop/excels/ downLoadUrl: "http://127.0.0.1:9453/download/%s"

4. Start the server using the provided startup script: bin/server.sh start

5. Verify the server is running by checking the logs and accessing ip:9453/sse/mcp for MCP messages or the configured download URL for generated Excel files.

Tips and notes:

• Ensure the savePath directory exists and is writable by the server user.
• The sse-endpoint and sse-message-endpoint define how clients subscribe to updates. The default paths in the example are /sse and /mcp, respectively.
• The download URL includes a placeholder %s for the file name; replace it with your actual file name when constructing the URL.
• If you modify the conf, restart the server to apply changes.
• This server is designed to work with the SSE-based MCP workflow; ensure your client supports receiving and sending MCP messages via the configured endpoints.