What kind of Excel operations does CellPilot support?

It supports comprehensive file operations, reading/writing cells and ranges, advanced searching (regex, numeric, date), sheet management (create, rename, delete), and cell/row/column manipulation (merge, insert, auto-size).

Do I need Microsoft Office installed to use CellPilot?

No, CellPilot is built as a self-contained application using C# and the NPOI library. It does not require Microsoft Office or the .NET runtime to be installed on your system.

CellPilot is a Model Context Protocol (MCP) server that empowers AI assistants like GitHub Copilot to programmatically read, write, search, and manipulate Excel files (.xlsx, .xls) through intuitive commands.

How does CellPilot integrate with AI assistants?

CellPilot functions as an MCP server, allowing AI assistants like GitHub Copilot in VS Code or Visual Studio to interpret and execute natural language requests for a wide array of Excel tasks.

CellPilot

Name: CellPilot
Author: ngandugilbert

byngandugilbert

•

Developer Tools

Productivity & Workflow

Enables AI assistants to programmatically read, write, and manipulate Excel files.

CellPilot is a powerful Model Context Protocol (MCP) server that empowers AI assistants, such as GitHub Copilot, with comprehensive capabilities for interacting with Excel spreadsheets (.xlsx and .xls). Built with C# and the NPOI library, it offers extensive functionality for managing Excel files, from basic operations like reading and writing cell data to advanced tasks like sheet management, cell merging, and column auto-sizing, making Excel manipulation accessible and efficient for AI-driven workflows across various platforms.

Key Features

01Advanced search capabilities across sheets and workbooks (including regex, numeric, and date ranges)

02Manipulate cells and structures (merge/unmerge, insert/delete rows/columns, auto-size columns)

03Manage sheets (create, rename, delete, copy) within workbooks

04Comprehensive Excel file operations (create, copy, get metadata)

051 GitHub stars

06Read and write cell values, ranges, and formulas

Use Cases

01Automate reading all data from specific Excel sheets for analysis or reporting.

02Programmatically create and populate new Excel files with structured data based on AI prompts.

03Enable AI assistants to search for specific values, apply complex formulas, or format data within workbooks.