Apply Excel formula to cell. Excel formula will write to cell with verification.

Validate Excel formula syntax without applying it.

Inspect a formula string for functions, references, and risky signals.

Apply formatting to a range of cells. Colors accept RRGGBB, #RRGGBB, AARRGGBB, or #AARRGGBB.

Apply formatting to multiple ranges in a single workbook pass. Colors accept RRGGBB, #RRGGBB, AARRGGBB, or #AARRGGBB.

Read a compact formatting summary for a worksheet range.

Read a compact table from an explicit sheet or the first workbook sheet.

Can return either array rows or object-shaped records, plus optional schema hints inferred from the returned rows.

Summarize a worksheet or native Excel table for agent-friendly orientation.

Recommend the best SheetForge read tool for the requested workbook target.

Filter, project, sort, and limit worksheet or table data. Filters support eq/neq/ne, comparisons, string matching, blank checks, and in/not_in with value or values.

Filter comparable worksheet or table data across multiple workbooks. Uses the same filter operators and aliases as query_table.

Union comparable worksheet or table data across multiple workbook files.

Enrich one workbook dataset from matching rows in one or more lookup workbooks.

Compute grouped metrics over worksheet-shaped data or a native Excel table.

Aggregate comparable worksheet or table data across multiple workbooks.

Read a native Excel table by its table name.

Supports compact table payloads, object-shaped record output, and optional inferred schema hints.

Create a new Excel workbook with an optional initial worksheet name.

Create new worksheet in workbook.

Create chart in worksheet from a contiguous range or explicit series.

This is the preferred chart authoring entry point; explicit-series calls are
also still available via create_chart_from_series for backward compatibility.

Create a chart from explicit series definitions for non-contiguous ranges.

List embedded charts in a workbook or worksheet.

Suggest free worksheet slots for charts or dashboard blocks.

Create pivot table in worksheet.

Creates a native Excel table from a specified range of data.

List native Excel tables for one worksheet or the whole workbook.

Copy a worksheet with tables, rules, charts, names, and layout settings.

Delete worksheet from workbook.

Rename worksheet in workbook.

Get metadata about workbook including sheets, ranges, etc.

Return a structural worksheet layout summary for safe dashboard-style edits.

Inspect workbook structures that overlap a worksheet range before mutation.

Explain a formula cell's direct references, upstream formula chain, and downstream dependents.

Detect circular workbook formula dependencies, including self-references.

Return a compact workbook inventory with sheets, tables, charts, and layout state.

Audit workbook structure for high-signal issues that affect agent workflows.

Turn workbook audit findings into prioritized next steps for SheetForge workflows.

Apply safe workbook repair actions with dry-run planning and before/after diff output.

Preview or commit an assertion-backed group of workbook mutations as one transaction.

Each operation is {"tool": "name", "args": {...}}. Supported tool names are
create_worksheet, write_data_to_excel, format_range, format_ranges, freeze_panes,
set_autofilter, set_column_widths, set_row_heights, autofit_columns, create_table,
and create_chart. Assertions support sheet_exists, cell_equals, range_equals,
range_values_unchanged, table_exists, freeze_panes_equals, autofilter_equals,
chart_exists, and no_cell_ref_errors.

Call preview first. Commit the identical plan with expected_workbook_sha256 and
changeset_token from that preview. Snapshot creation defaults to enabled.

Diff two workbook files and report structural changes plus sampled cell-value changes.

Create a verified workbook snapshot without overwriting an existing file.

Create a workbook-level or sheet-scoped named range.

Inspect a named range, including scope, destinations, and broken-reference signals.

List workbook defined names and their destinations.

Delete a workbook-level or sheet-scoped named range.

Merge a range of cells.

Unmerge a range of cells.

Get merged cells in a worksheet.

Set or clear worksheet freeze panes.

Set worksheet autofilter for an explicit or inferred range.

Set worksheet visibility to visible, hidden, or veryHidden.

Get worksheet protection status and option flags.

Enable or disable worksheet protection with optional capability flags.

Set or clear worksheet print area.

Set, preserve, or clear repeating print title rows and columns.

Set explicit widths for one or more worksheet columns.

Auto-fit worksheet columns based on content width.

Set explicit heights for one or more worksheet rows.

Copy a range of cells to another location.

Delete a range of cells and shift remaining cells.

Validate if a range exists and is properly formatted.

Inspect worksheet data validation rules with stable rule indexes.

Remove worksheet data validation rules by index or remove all broken ones.

Inspect worksheet conditional formatting rules with stable rule indexes.

Remove worksheet conditional formatting rules by index or remove all broken ones.

Insert one or more rows starting at the specified row.

Insert one or more columns starting at the specified column.

Delete one or more rows starting at the specified row.

Delete one or more columns starting at the specified column.

Search for cells matching a value in a worksheet.

List all sheets in a workbook with row/column counts. Quick overview before reading data.

Append dictionary-shaped rows by matching worksheet headers on a worksheet dataset.

Append rows to a native Excel table and expand its range safely.

Update matching rows in a native Excel table and append missing keys.

Update existing table rows using a named key column.