open_excel_and_list_sheetsLABSCO SUMMARY
Spreadsheet edits without a spreadsheet application.
Because it reads the file format directly, this works on machines that have no Excel and no office suite at all — a server or a container included. The coordinate option on reads is the detail that pays off in practice: a mostly-empty range comes back as the cells that have something in them, rather than as a wall of blanks.
What it is
A single-binary Excel server built on the OpenXLSX library. It opens a workbook and lists its sheets, reads a range of cells, writes a two-dimensional block of values back, and creates a new workbook at a path you give it.
What you get
- A workbook opened and its sheet names listed — also the step that sets which file the later calls act on
- The contents of a cell range in a named sheet, optionally with each non-empty cell's coordinates so sparse areas stay readable
- A block of values written into a range, accepting text, numbers, booleans and blanks
- A new xlsx file created at an absolute path
- Interface language switchable from a file you drop next to the binary
Requirements
The compiled binary — the project builds with CMake into one executable, needing no Excel and no runtime beyond itself. Clients connect to it over an event-stream transport on the local machine. No account, no key.
Setup effort
Build from source — git clone https://github.com/smileFAace/MCP-ExcelAutoCpp.git
USE CASES
01
Finding your way around a workbook someone sent
Open the file and list its sheets first, which also fixes it as the target for everything that follows.
02
Pulling numbers out of a report
Read the range you care about from the named sheet, rather than loading the whole workbook.
03
Filling in a block of a template
Write a two-dimensional block of values into the range in one call, mixing text, numbers and blanks.
04
Reading a sparse sheet without drowning in blanks
Ask for the non-empty cells with their coordinates, so scattered data comes back readable.
05
Starting a new workbook
Create the file at an absolute path, then open it and start writing.
4 tools
Listed in project docs. Your client may show a different list.
get_sheet_range_contentset_sheet_range_contentcreate_xlsx_file_by_absolute_pathBEFORE YOU INSTALL
What to know first
Tools you get
4 tools named in the project's documentation.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
This one is built from source rather than installed with a single command.
Server setup
Ensure you have a C++17 compiler, CMake (>= 3.15), and Ninja installed.
TERMINAL
git clone https://github.com/smileFAace/MCP-ExcelAutoCpp.git
cd MCP-ExcelAutoCpp
cmake -G "Ninja" -S . -B build
cmake --build build
./bin/ExcelAutoCppAdd the config block below to your MCP client and refresh.
MCP Clients
Any MCP client
ANY MCP CLIENT · JSON
{
"mcpServers": {
"excel-auto-cpp": {
"url": "http://localhost:8888/sse"
}
}
}
