CellPilotMCP 0.0.2

.NET 10.0 This package targets .NET 10.0. The package is compatible with this framework or higher. 
{
  "servers": {
    "cellpilotmcp": {
      "type": "stdio",
      "command": "dnx",
      "args": ["cellpilotmcp@0.0.2", "--yes"]
    }
  }
}
This package contains an MCP Server. The server can be used in VS Code by copying the generated JSON to your VS Code workspace's .vscode/mcp.json settings file. 
dotnet tool install --global CellPilotMCP --version 0.0.2
This package contains a .NET tool you can call from the shell/command line. 
dotnet new tool-manifest
                    


                            if you are setting up this repo
                        

                    

                
dotnet tool install --local CellPilotMCP --version 0.0.2
This package contains a .NET tool you can call from the shell/command line. 
#tool dotnet:?package=CellPilotMCP&version=0.0.2
                    


                    

                
nuke :add-package CellPilotMCP --version 0.0.2

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).

Built with C# and the NPOI library, this MCP server provides comprehensive Excel functionality through a set of intuitive tools.

Features

📁 File Operations

  • GetExcelFileInfo - Get 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 a specific cell's value
  • ReadRange - Read a range of cells as a 2D array
  • GetSheetData - Get all data from a sheet
  • GetCellFormula - Retrieve 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 range
  • SearchDateRange - Find cells with dates in a 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 built as a self-contained application and does not require the .NET runtime to be installed. Supported 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 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 ask 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"

More Information

This MCP server uses the ModelContextProtocol C# SDK.

MCP Resources:

IDE Configuration:

License

MIT

Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last Updated
0.0.2 923 12/2/2025
0.0.1 872 12/2/2025