Cellpilot MCP

🚀 CELLPILOT MCP

A powerful Model Context Protocol (MCP) server that enables AI assistants like GitHub Copilot to read, write, and manipulate Excel files (.xlsx and .xls).

CELLPILOT MCP, built with C# and the NPOI library, offers a comprehensive set of intuitive tools for Excel file operations through the Model Context Protocol (MCP).

✨ Features

📁 File Operations

• GetExcelFileInfo - Retrieve file metadata, including sheet names, row counts, and column counts.
• CopyExcelFile - Copy Excel files to new locations.
• ListSheets - List all sheet names in a workbook.
• CreateWorkbook - Create new Excel workbooks (.xlsx or .xls).

📖 Reading Data

• ReadCell - Read the value of a specific cell.
• ReadRange - Read a range of cells as a 2D array.
• GetSheetData - Retrieve all data from a sheet.
• GetCellFormula - Fetch formulas from cells.

🔍 Searching

• SearchInSheet - Search for values within a sheet.
• SearchInWorkbook - Search across all sheets in a workbook.
• SearchInColumn - Search within a specific column.
• SearchWithRegex - Search using regular expressions.
• SearchNumericRange - Find cells with numbers in a specified range.
• SearchDateRange - Find cells with dates in a specified range.

✍️ Writing Data

• WriteCell - Write a value to a cell.
• WriteRange - Write a 2D array of data.
• SetCellFormula - Set formulas in cells.
• ClearRange - Clear content from a range of cells.

📊 Sheet Management

• CreateSheet - Create new sheets.
• RenameSheet - Rename existing sheets.
• DeleteSheet - Remove sheets from workbooks.
• CopySheet - Duplicate sheets within a workbook.

🔧 Cell & Row/Column Manipulation

• InsertRow / DeleteRow - Add or remove rows.
• InsertColumn / DeleteColumn - Add or remove columns.
• MergeCells / UnmergeCells - Merge or unmerge cell ranges.
• ListMergedRegions - List all merged regions in a sheet.
• AutoSizeColumn - Auto - fit column width to content.
• SetColumnWidth - Set specific column widths.

📦 Supported Platforms

The MCP server is a self - contained application that doesn't require the .NET runtime to be installed. It supports the following platforms:

• win-x64 / win-arm64
• osx-arm64
• linux-x64 / linux-arm64 / linux-musl-x64

📦 Installation

From NuGet.org

Configure the MCP server in your IDE using the dnx command:

VS Code - Create .vscode/mcp.json:

{
  "servers": {
    "CellPilotMCP": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "CellPilotMCP",
        "--version",
        "0.0.1",
        "--yes"
      ]
    }
  }
}

Visual Studio - Create .mcp.json in the solution directory with the same structure.

From Source (Local Development)

{
  "servers": {
    "CellPilotMCP": {
      "type": "stdio",
      "command": "dotnet",
      "args": [
        "run",
        "--project",
        "<PATH TO PROJECT DIRECTORY>"
      ]
    }
  }
}

💻 Usage Examples

Once configured, you can instruct your AI assistant to perform Excel operations:

• "Read all data from Sheet1 in my-file.xlsx"
• "Create a new Excel file with columns for Name, Email, and Phone"
• "Search for all cells containing 'Total' in the workbook"
• "Write a SUM formula in cell C10 that adds C1:C9"
• "Merge cells A1 through D1 for a header row"
• "Auto-size all columns in Sheet1"

📚 Documentation

This MCP server uses the ModelContextProtocol C# SDK.

MCP Resources:

• Official Documentation
• Protocol Specification
• GitHub Organization

IDE Configuration:

• Use MCP servers in VS Code (Preview)
• Use MCP servers in Visual Studio (Preview)

📄 License

MIT