mcp-server-xlwings

Name: mcp-server-xlwings
Author: geniuskey

@geniuskey

Repository

About mcp-server-xlwings

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

#excel #xlwings

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.