Description

This MCP server provides comprehensive Excel file manipulation capabilities through a C++ implementation using OpenXLSX, enabling AI assistants to create, open, edit, and format Excel spreadsheets programmatically. Built with modern C++ and integrated with the cpp-mcp library, it offers extensive functionality including cell value operations, worksheet management, formatting controls (fonts, colors, alignment), row/column operations, range manipulation, and cell merging/unmerging. The implementation wraps OpenXLSX in a clean ExcelOperator class with template-based type safety for different data types, supports both individual cell operations and bulk data operations, and includes advanced styling capabilities for professional spreadsheet creation, making it valuable for automated report generation, data processing workflows, and Excel-based business automation tasks.

Installation

git clone https://github.com/smilefaace/mcp-excelautocpp

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "excel-automation": {
      "command": "node",
      "args": [
        "path/to/server.js"
      ]
    }
  }
}