mcp-server-excel

概述

ExcelMcp是一个全面的模型上下文协议(MCP)服务器，使AI助手能够通过自然语言命令自动执行Microsoft Excel操作。它使用Excel的原生COM API安全地直接控制Excel应用程序，而不是直接操作XLSX文件。该项目提供MCP服务器和CLI两种接口，共有25个专业工具，涵盖Power Query、DAX、Excel表格、数据透视表、图表、VBA、范围、工作表、连接、命名范围、文件、计算模式、切片器、条件格式、截图和窗口管理。两种接口共享相同的后端服务，确保功能一致性，同时针对不同使用场景进行优化。

试试问 AI

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

• power_query

  Atomic workflows, M code management, load destinations for Power Query

  试试:Use Power Query to import products.csv and load it to the Data Model试试:Export all Power Query M code to files for version control
• data_model_dax

  Create and manage DAX measures, relationships, and model structure

  试试:Create a measure for Total Revenue using SUMX试试:Create a relationship between the Orders and Products tables using ProductID
• excel_tables

  Manage Excel tables including filtering, sorting, and structured references

  试试:Convert this range to an Excel Table with a blue style and add a totals row试试:Format the Price column as currency and highlight values over $500 in green
• pivot_tables

  Create and manage PivotTables including fields, aggregations, and calculated members

  试试:Create a PivotTable from this data showing total sales by Product试试:Add a calculated field to the PivotTable showing profit margin
• charts

  Create and configure charts including series, formatting, and data labels

  试试:Create a bar chart from the sales data试试:Add a trendline to the existing chart
• range

  Get/set values, formulas, formatting, validation, and protection for ranges

  试试:Put this data in A1:C3 - Name, Age, City / Alice, 30, Seattle / Bob, 25, Portland试试:Add a formula column that calculates Quantity times Unit Price
• worksheets

  Manage worksheets including lifecycle, colors, visibility, and moves

  试试:Rename the active sheet to 'Sales Report'试试:Hide all worksheets except the first one
• connections

  Manage OLEDB/ODBC connections and refresh data sources

  试试:Refresh all data connections in this workbook试试:Create a new connection to the SQL Server database
• named_ranges

  Create and manage named ranges for parameters and configuration

  试试:Create a named range 'TaxRate' with value 0.07试试:Use the named range 'RegionFilter' to filter the PivotTable
• files

  Manage session, workbook creation, and IRM/AIP-protected file support

  试试:Create a new Excel file called SalesTracker.xlsx试试:Save the current workbook with IRM protection
• slicers

  Create and manage slicers for interactive filtering of PivotTables and Tables

  试试:Create a slicer for the Region field试试:Connect the slicer to multiple PivotTables
• screenshot

  Capture ranges or sheets as PNG for visual verification

  试试:Take a screenshot of the current sheet试试:Capture A1:G10 as an image for documentation

可对比工具

安装

{
  "mcpServers": {
    "excel": {
      "command": "path/to/mcp-excel.exe",
      "args": []
    }
  }
}

FAQ

这兼容Mac或Linux吗？

不兼容，由于使用COM互操作，这仅适用于Windows。需要安装Microsoft Excel。

我可以将其用于服务器端自动化吗？

不可以，这是为安装并运行Excel的桌面环境设计的。对于服务器端处理，请使用与Excel兼容的库，如ClosedXML或EPPlus。

mcp-server-excel 对比