Sezzlee Excel vs Xlsx Tools MCP

Sezzlee Excel tools

No tool names declared yet. Check the project README from the listing page.

Xlsx Tools MCP tools 29

• restore_backupRestore a backup file over a target workbook atomically. Args: backup_path: Path to the .bak file to restore from. target_path: Path to the target .xlsx/.xlsm file to overwrite.
• list_configured_filesList files preloaded at server startup (via the XLSX_MCP_FILES env var). Call this first if unsure which files are available — every other tool's `path` argument accepts these names directly (or can be omitted if only one is configured), no filesystem search needed.
• list_sheetsList every sheet in a workbook with its approximate row/column counts. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured.
• get_workbook_infoGet workbook-level metadata: sheets, exact dimensions, active sheet, defined names. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured.
• read_sheetRead cell values from a sheet. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: Optional A1-style range (e.g. "B2:F20"). Omit to read the full used area. max_rows: Optional cap on the number of rows returned, to bound response size for large sheets. offset_row: Skip a number of data rows (0-indexed from first data row). format: "array" (default 2D list), "records" (list of dicts, first row as keys), or "markdown" (table string).
• get_cellGet full detail for a single cell: value, formula, number format, font, fill, merge, comment. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell: Cell reference, e.g. "C5".
• search_workbookSearch cell values across one or all sheets for a substring match. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. query: Substring to search for. sheet: Restrict the search to one sheet; omit to search every sheet. match_case: Case-sensitive match when True. limit: Optional cap on the number of matches returned, to bound response size for large sheets.
• aggregate_sheetGroup and aggregate sheet data with pandas (e.g. sum sales by region). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. group_by: Column names to group by (taken from the header row). agg: Mapping of column name to aggregation function, e.g. {"amount": "sum"}. cell_range: Optional A1-style range to read before aggregating. has_header: Whether the first row of the range holds column names.
• create_workbookCreate a new .xlsx workbook. Args: path: Path for the new file. New files aren't preloaded, so this must be a real path. sheets: Sheet names to create (defaults to a single "Sheet1"). overwrite: Replace an existing file at path when True.
• write_cellsWrite values and/or formulas into specific cells, then recalculate the workbook. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cells: List of {"cell": "A1", "value": ...} or {"cell": "B1", "formula": "=A1*2"}. create_sheet_if_missing: Create the sheet first if it doesn't exist yet. recalculate: Run the LibreOffice recompute pass after saving. Returns: Write result including `errors_found` — any Excel error values produced by recalculation.
• append_rowsAppend rows after the last used row of a sheet, then recalculate the workbook. Set `recalculate=False` to skip the LibreOffice recompute (e.g. for structurally complex workbooks you don't want round-tripped). Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. rows: List of rows, each a list of cell values in column order. create_sheet_if_missing: Create the sheet first if it doesn't exist yet. recalculate: Run the LibreOffice recompute pass after saving.
• create_sheetAdd a new empty sheet to an existing workbook. Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Name for the new sheet. index: Zero-based position to insert at; omit to append at the end.
• +17 more on the listing page