MCP 服务器

Excel MCP Server

一个 MCP 服务器，提供全面的 Excel 文件操作、数据分析和可视化功能，用于处理各种电子表格格式，如 XLSX、CSV 和 JSON。

Tools

read_excel

Read an Excel file and return its contents as a string. Args: file_path: Path to the Excel file sheet_name: Name of the sheet to read (only for .xlsx, .xls) nrows: Maximum number of rows to read header: Row to use as header (0-indexed) Returns: String representation of the Excel data

write_excel

Write data to an Excel file. Args: file_path: Path to save the Excel file data: Data in CSV or JSON format sheet_name: Name of the sheet (for Excel files) format: Format of the input data ('csv' or 'json') Returns: Confirmation message

update_excel

Update an existing Excel file with new data. Args: file_path: Path to the Excel file to update data: New data in CSV or JSON format sheet_name: Name of the sheet to update (for Excel files) format: Format of the input data ('csv' or 'json') Returns: Confirmation message

analyze_excel

Perform statistical analysis on Excel data. Args: file_path: Path to the Excel file columns: Comma-separated list of columns to analyze (analyzes all numeric columns if None) sheet_name: Name of the sheet to analyze (for Excel files) Returns: JSON string with statistical analysis

filter_excel

Filter Excel data using a pandas query string. Args: file_path: Path to the Excel file query: Pandas query string (e.g., "Age > 30 and Department == 'Sales'") sheet_name: Name of the sheet to filter (for Excel files) Returns: Filtered data as string

pivot_table

Create a pivot table from Excel data. Args: file_path: Path to the Excel file index: Column to use as the pivot table index columns: Optional column to use as the pivot table columns values: Column to use as the pivot table values aggfunc: Aggregation function ('mean', 'sum', 'count', etc.) sheet_name: Name of the sheet to pivot (for Excel files) Returns: Pivot table as string

export_chart

Create a chart from Excel data and return as an image. Args: file_path: Path to the Excel file x_column: Column to use for x-axis y_column: Column to use for y-axis chart_type: Type of chart ('line', 'bar', 'scatter', 'hist') sheet_name: Name of the sheet to chart (for Excel files) Returns: Chart as image

data_summary

Generate a comprehensive summary of the data in an Excel file. Args: file_path: Path to the Excel file sheet_name: Name of the sheet to summarize (for Excel files) Returns: Comprehensive data summary as string

README

Excel MCP 服务器

一个提供全面 Excel 文件管理和数据分析功能的 MCP 服务器。

功能

Excel 文件操作
- 读取多种 Excel 格式 (XLSX, XLS, CSV, TSV, JSON)
- 写入和更新 Excel 文件
- 获取文件信息和工作表名称
数据分析
- 汇总统计和描述性分析
- 数据质量评估
- 数据透视表
- 过滤和查询数据
可视化
- 从 Excel 数据生成图表和绘图
- 创建数据预览
- 将可视化效果导出为图像

安装

创建一个新的 Python 环境 (推荐):

# 使用 uv (推荐)
uv init excel-mcp-server
cd excel-mcp-server
uv venv
source .venv/bin/activate  # 在 Windows 上: .venv\Scripts\activate

# 或者使用 pip
python -m venv .venv
source .venv/bin/activate  # 在 Windows 上: .venv\Scripts\activate

安装依赖:

# 使用 uv
uv pip install -r requirements.txt

# 或者使用 pip
pip install -r requirements.txt

与 Claude Desktop 集成

安装 Claude Desktop
打开设置并转到开发者选项卡
编辑 claude_desktop_config.json:

{
  "mcpServers": {
      "command": "uvx",
      "args": [
        "mcp-excel-server"
      ],
      "env": {
        "PYTHONPATH": "/path/to/your/python"
      }
  }
}