mcp-server-xlwings

Name: mcp-server-xlwings
Author: geniuskey

@geniuskey

代码仓库

关于 mcp-server-xlwings

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

#excel #xlwings

基本信息

分类

其他

传输方式

stdio

发布者

geniuskey

提交者

Euiyun Edwin Kim

配置

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

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from mcp-server-xlwings

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.