Close an open Excel workbook by file name. Discard unsaved changes by default, or pass save=True to write them first. Returns the closed name and remaining open workbooks.
MIT
749,494 tools. Updated 2026-11-06 01:12
"An MCP server for reading, writing, and formatting Excel workbooks locally" matching MCP tools:
- Convert an existing Excel workbook into a runnable C# script that rebuilds an equivalent file, using the Kookerella.CsOpenXmlDsl API for full formatting and feature coverage.MIT
- Get a list of all Excel workbooks currently open in the ModelRisk environment to manage risk modeling sessions.MIT
- Convert a local UTF-8 JSON file to Excel (XLSX), with configurable worksheet names, formatting, and data conversion options.MIT
- Identify Excel workbooks and Power BI Desktop models available as sources, and learn about other supported source forms for Power Query queries.MIT
- Copy selected Power Query (M) queries between Excel workbooks or Power BI projects, automatically including their dependencies to keep them functional.MIT
Matching MCP Servers
- FlicenseAqualityDmaintenanceEnables document conversion between PDF, DOCX, and Markdown formats to facilitate reading and editing complex files in AI tools like Claude Desktop or Cursor. It utilizes marker-pdf and pandoc to provide structured text versions of documents, helping to manage context and support unsupported file types.11-
- AlicenseNot gradedqualityCmaintenanceProvides full read and write access to Excel workbooks (sheets, cell ranges, tables, formulas, formatting, and cross-workbook references) via MCP, running locally or as an HTTP/SSE service.27 npmMIT
Matching MCP Connectors
Read an invoice into seller, tax id, date, and amounts.
Life Path number, Sun sign and Chinese zodiac for a birth date, plus Lunar New Year lookups.
- Convert Markdown tables into Excel spreadsheets. Extracts pipe-tables and creates XLSX files with each table as a dedicated worksheet, turning Markdown content into formatted workbooks for data analysis.MIT
- Apply font, fill, border, alignment, and number formatting to a cell range in an Excel file. Each attribute can be set individually or left unchanged.MIT
- Read data from an Excel range or retrieve a sheet summary. Optionally fetch detailed cell information, formulas, and formatting, or read all sheets in one call.MIT
- Lists Analysis for Office workbooks stored in BW with where-used details, so you can find which workbooks use a query or planning function, or sit in a role menu, without downloading files.MIT
- Lists Excel workbooks connected to the bridge server, showing workbook IDs and connection status so you can find the workbookId needed for other Excel tools when multiple workbooks are open.MIT
- List all sheets in an Excel workbook with their dimensions and metadata, including row/column counts, data ranges, merged cell counts, and image count, to understand the workbook structure before reading its contents.MIT
- Extract cell formulas, calculated values, or formatting details from Excel ranges in live workbooks or .xlsx files without Excel installed.MIT
- Inspect Excel workbook structure by retrieving sheet names, active sheet, dimensions, and header preview before reading large files.MIT
- Identify every Excel table (ListObject) in a local .xlsx workbook, including name, sheet, range, and column details. Essential when pandas cannot detect structured tables.MIT
- Read cell data from Excel sheets with pagination, formatting markers, and automatic skip of hidden rows. Supports large files and reveals author's emphasis marks.MIT
- List all currently open Excel workbooks with their names, file paths, and sheet counts.MIT
- Connect to a J-Link debugger and begin RTT monitoring. Required before reading or writing RTT data.MIT
- Forces Excel to recalculate an open workbook after writes, ensuring formula results are current before reading them back.MIT
- Apply formatting to Excel cells, including font styles, colors, alignment, borders, and number formats, for both live workbooks and .xlsx files without Excel.MIT
- Retrieve a Tableau Public user's workbook categories, including names, contained workbooks, view counts, and favorites. Supports pagination for exploring large collections.Apache 2.0