@libraz/formulon-mcp

Save an open workbook session to xlsx.

Return the loaded Formulon engine version.

Read broad workbook metadata such as registered functions or external links.

List, add, remove, remove by index, or clear merged ranges on a sheet.

Evaluate one Excel formula with Formulon. With sessionId, evaluates read-only against the open workbook (resolving refs, defined names, and ROW()/COLUMN() anchored at the given cell) without mutating it.

Create an in-memory workbook session from an existing xlsx file or a new default workbook.

List currently open in-memory workbook sessions.

Close an in-memory workbook session and release its native workbook handle.

Inspect an open workbook session, optionally including sparse non-empty cells.

Recalculate an open workbook session.

Search text cell values and/or formula text in an open workbook session.

Replace matching text cell values and/or formula text in an open workbook session.

Return stable cell, layout, merge, row/column, protection, and optional style data for one or all sheets.

Detect table-like regions, label-value pairs, and total-like regions with rule-based evidence.

Classify workbook shape such as invoice, list, report, schedule, or form using deterministic features and evidence.

Apply cell mutations to an open workbook session. Cells may use A1 refs or zero-based row/col.

Write a 2D block of values starting at an anchor cell. Each element\'s JSON type picks the cell type: number, boolean, or string. Use {"f":"=SUM(A1:A3)"} for a formula and null to skip a cell. Far more compact than set_cells for tables.

Add, remove, rename, or move a sheet in an open workbook session.

Add, replace, or remove a workbook-scoped defined name. Empty formula removes it.

Insert or delete rows/columns in an open workbook session.

Set sheet zoom, frozen panes, or tab hidden flag.

Get one cell from either an open session or a workbook path. A1 refs are supported for sessions. Date/currency/percent cells carry a decoded `formatted` string alongside the raw value.

Get a rectangular A1 range from an open workbook session. Output is sparse (blank cells omitted), clipped to the sheet's used range, and capped at maxCells. Cells with a date/currency/percent number format carry a decoded `formatted` string (for example an ISO date) alongside the raw value.

List, get, set, or remove a cell comment.

List, add, remove, remove by index, or clear hyperlinks on a sheet.

List, add, remove by index, or clear data validations on a sheet.

List, add, remove by index, clear, or evaluate conditional format rules.

Read precedents, dependents, or spill info for a cell. Results carry A1 references (with sheet names), not raw indices.

List column-width/row-height overrides, or set width/height, hidden, or outline level. Columns act on an inclusive [first, last] span; rows act on a single row index.

List functions, get metadata, localize names, or canonicalize localized names.

Low-level allowlisted access to the Formulon Workbook API for advanced features: pivot tables, styles, merges, comments, hyperlinks, validations, conditional formats, dependency graph, spill info, and more.

Load an xlsx workbook path and return a one-shot summary.

Create or load a workbook, apply zero-based cell mutations, recalculate, and save.