Excel-MCP-Server-Master

概述

Excel MCP Server通过Model Context Protocol提供完整的Excel操作功能，使用户能够在无需安装Microsoft Excel的情况下读取、写入、分析和自动化Excel文件（.xlsx、.xlsm、.xltx、.xltm）。它支持创建图表、数据透视表、仪表板以及导入/导出多种格式数据（CSV、JSON、PDF）等高级功能。该服务器可与Claude等AI助手无缝集成，并提供专业格式化选项，用于创建出版级文档。

试试问 AI

装完之后，这里有 7 个你可以让 AI 做的事：

• create_workbook_tool

  Create a new Excel workbook without Microsoft Excel

  试试:Create a new sales report workbook试试:Generate an empty budget spreadsheet for me
• open_workbook_tool

  Open an existing Excel file (XLSX, XLSM, XLTX, XLTM)

  试试:Open the financial data spreadsheet试试:Load the Q3 report Excel file
• write_sheet_data_tool

  Write data to an Excel worksheet

  试试:Enter sales data into the spreadsheet试试:Update the monthly figures sheet
• list_sheets_tool

  List all worksheets in an Excel workbook

  试试:Show me all sheets in this workbook试试:What sheets are available in the report file
• add_sheet_tool

  Add a new worksheet to an Excel workbook

  试试:Create a summary sheet at the beginning试试:Add a new worksheet called 'Analysis'
• create_formatted_table_tool

  Create a formatted Excel table with professional styling

  试试:Format the sales data as a professional table试试:Create a styled table with alternating row colors
• add_chart_tool

  Create charts in Excel files (column, bar, line, pie, scatter)

  试试:Add a column chart showing quarterly sales试试:Create a pie chart of market share data
• import_data_tool

  Import data from CSV, JSON, or SQL sources into Excel

  试试:Import data from sales.csv into a new sheet试试:Load customer information from JSON file
• export_data_tool

  Export Excel data to CSV, JSON, or PDF formats

  试试:Export the data as CSV for analysis试试:Convert the report to PDF format
• filter_data_tool

  Filter Excel data based on specified criteria

  试试:Filter sales data for regions with growth over 10%试试:Show only products with inventory below 50
• create_dashboard_tool

  Create dynamic Excel dashboards with tables and charts

  试试:Build an executive dashboard with key metrics试试:Create a performance dashboard with multiple charts
• update_cell_tool

  Update a specific cell in an Excel worksheet

  试试:Update cell B5 with the latest sales figure试试:Change the title in cell A1 to 'Annual Report'

可对比工具

安装

npx @guillehr2/excel-mcp-server@latest

npm install -g @guillehr2/excel-mcp-server

{
  "mcpServers": {
    "excel-master": {
      "command": "npx",
      "args": [
        "-y",
        "@guillehr2/excel-mcp-server@latest"
      ]
    }
  }
}

FAQ

支持哪些Excel文件格式？

服务器支持XLSX、XLSM、XLTX和XLTM格式的读写操作。

是否需要安装Microsoft Excel？

不需要，服务器无需在系统上安装Microsoft Excel即可操作Excel文件。

可以创建哪些类型的图表？

服务器支持创建多种图表类型，包括柱形图、条形图、折线图、饼图、散点图和面积图，并提供多种样式选项。

Excel-MCP-Server-Master 对比