mcp-server-xlwingsExcel Automation for AI Agents

MCP server that controls live Excel via COM. Works with DRM-protected files. Windows only.

🔒

DRM-Protected Files

Uses COM automation to talk to the running Excel process. Opens any file that Excel can open, including encrypted and DRM-protected documents.

⚡

Read selections, run VBA macros, get live formula results, and force recalculation — features impossible with file-based libraries.

🛠️

Consolidated tool set covering read, write, format, search, formulas, styles, charts, and macro execution.

📊

Automatic merged cell detection, region discovery, and sheet structure analysis for complex enterprise spreadsheets.

🔄

Read all sheets at once with sheet="*", get formulas in bulk, and query cell styles across ranges in a single call.

🚀

One-line setup with uvx. Works with Claude Desktop, Claude Code, Cursor, Windsurf, Roo Code, and Continue.

Add to your MCP client config and start using immediately:

json

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

Then ask your AI agent:

"What's in the spreadsheet I have open?"

The agent will call get_active_workbook() and read_data() to explore your Excel file.