MCP.so
登录

Excel MCP Server

@zhiwei5576

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

zhiwei5576

关于 Excel MCP Server

Excel数据处理微服务

Excel MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "excel-mcp-server-zhiwei5576": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@zhiwei5576/excel-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

Excel MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Excel MCP Server?

Excel MCP Server is an Excel file processing server based on the Model Context Protocol (MCP), providing functionalities for reading, writing, and analyzing Excel files. It is designed for developers and AI agents that need to programmatically interact with Excel files.

How to use Excel MCP Server?

Install and configure the server by adding it to your MCP servers configuration, optionally setting environment variables like LOG_PATH, CACHE_MAX_AGE, CACHE_CLEANUP_INTERVAL, LOG_RETENTION_DAYS, and LOG_CLEANUP_INTERVAL. Invoke built-in tools such as readSheetNames, readDataBySheetName, writeDataBySheetName, or analyzeExcelStructure to perform Excel operations.

Key features of Excel MCP Server

  • Read, write, and analyze Excel files via MCP tools
  • Automatic file content caching with scheduled cleanup
  • Manual cache clearing and cache management
  • Automatic operation logging with periodic log cleanup
  • Support for multiple worksheets and sheet management
  • Export Excel file structure to a new template file

Use cases of Excel MCP Server

  • Extracting data from Excel spreadsheets for further processing
  • Creating new Excel files with structured data from an AI agent
  • Analyzing Excel file structure (sheets and headers) for automation
  • Updating specific worksheets in existing Excel files

常见问题

1

What are the dependencies and runtime requirements?

Dependencies include `@modelcontextprotocol/sdk` (^1.7.0), `xlsx` (^0.18.5), and `typescript` (^5.8.2). Development dependencies also require `@types/node`, `nodemon`, and `ts-node`.

2

How is data cached and what are the default cache settings?

Cache expires after 1 hour by default, with automatic cleanup every 4 hours. Cache can be manually cleared per file using the `clearFileCache` tool.

3

Where are logs stored and how are they managed?

Logs are stored in a configurable `LOG_PATH` (default: 'logs' folder under the application root). Logs are retained for 7 days with cleanup occurring every 24 hours by default.

4

How do I install Excel MCP Server?

Install via Smithery using `npx -y @smithery/cli install @zhiwei5576/excel-mcp-server --client claude` or manually by adding configuration to the MCP servers JSON with `npx --yes @zhiweixu/excel-mcp-server`.

5

What license is Excel MCP Server under?

It is licensed under the MIT License, allowing commercial and non-commercial use, modification, and distribution with retention of the original copyright notice.

评论

其他 分类下的更多 MCP 服务器