CellPilot

概要

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.

主な機能

• Advanced search capabilities across sheets and workbooks (including regex, numeric, and date ranges)
• Manipulate cells and structures (merge/unmerge, insert/delete rows/columns, auto-size columns)
• Manage sheets (create, rename, delete, copy) within workbooks
• Comprehensive Excel file operations (create, copy, get metadata)
• 1 GitHub stars
• Read and write cell values, ranges, and formulas

ユースケース

• Automate reading all data from specific Excel sheets for analysis or reporting.
• Programmatically create and populate new Excel files with structured data based on AI prompts.
• Enable AI assistants to search for specific values, apply complex formulas, or format data within workbooks.