MCP Server Xlwings

@geniuskey

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

geniuskey

提交者

Euiyun Edwin Kim

关于 MCP Server Xlwings

MCP server for Excel automation via xlwings COM. Works with DRM-protected files.

#excel#xlwings

MCP Server Xlwings 配置

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

{
  "mcpServers": {
    "xlwings": {
      "command": "uvx",
      "args": [
        "mcp-server-xlwings"
      ]
    }
  }
}

MCP Server Xlwings 工具

工具列表暂未提供

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

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

概览

What is mcp-server-xlwings?

mcp-server-xlwings is an MCP server that automates Excel via xlwings COM, enabling interaction with live Excel sessions, including DRM-protected files. It is designed for enterprise users who need to read/write Excel data that other libraries (like openpyxl or pandas) cannot access due to encryption, locked files, or running macros.

How to use mcp-server-xlwings?

Install with uvx mcp-server-xlwings (recommended) or pip install mcp-server-xlwings. Configure your MCP client (e.g., Claude Desktop, Claude Code, Roo Code, Cursor, Windsurf, Continue) by adding a JSON or YAML entry pointing to the uvx command and server name. All tools default to the active workbook when no workbook is specified.

Key features of mcp-server-xlwings

Uses COM automation for live Excel interaction
Works with DRM-protected and locked files
Reads current selection and active workbook
Runs VBA macros and returns values
Sets formulas with live calculated results
Provides 11 tools for read, write, format, sheet, and macro actions

Use cases of mcp-server-xlwings

See what the user is working on in their open spreadsheet
Summarize selected data directly from the active workbook
Run existing VBA macros and retrieve return values
Add formulas and formatting to enterprise Excel files
Read formulas with their calculated values across multiple sheets

常见问题

What makes mcp-server-xlwings different from openpyxl/pandas?

openpyxl and pandas read .xlsx files directly from disk. mcp-server-xlwings uses COM automation to talk to the running Excel process, allowing it to open DRM-protected files, interact with live formulas and macros, and work with files locked by other processes.

What are the system requirements?

Windows (Excel COM automation is Windows-only), Microsoft Excel installed, and Python 3.10 or higher.

Can it run VBA macros?

Yes. The `run_macro` tool executes a VBA macro and returns its return value.

Does it support reading the user's current selection?

Yes. The `get_active_workbook` tool returns the workbook name, sheets, and the current selection data.

Is mcp-server-xlwings cross-platform?

No. It requires Windows because of its dependency on COM automation for Microsoft Excel.

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

ICSS

chokcoco

不止于 CSS

20.7K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K