Skip to main content
Glama
basis1: Excel engine for AI agents (formulas, recalculation, audit)

basis1: Excel engine for AI agents (formulas, recalculation, audit)

Official

Get formula range

get_formula_range
Read-only

Read formulas and computed values from a single cell or rectangular range in a session to check what a cell or block calculates.

Instructions

Read the formulas and computed values of one cell or a rectangular range in a session: the way to check what a cell or a block of cells computes. Pass a single cell ("B4", "Sheet1!B4") or a range ("A1:D10"). Returns {worksheet, range, cell_count, cells: [{cell, formula, value, value_type}]}, with formula including its leading "=" (null for constants and empty cells) and value_type "number", "string", "boolean", "error" or "empty". Read a block in one call rather than cell by cell; to read values by defined name use get_outputs, and for the cells that feed one use trace_dependencies. Every cell in the rectangle is returned, up to 2,000 cells a call; a larger range fails with range_too_large, so read a big block in pieces. An unknown sheet or malformed range fails the call.

Input Schema

NameRequiredDescriptionDefault
rangeYesA cell or range, e.g. "B4", "A1:D10" or "Sheet1!B2:F2"
session_idYesSession ID returned by create_session (list_sessions shows the open ones)

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed2 schema fields changedv0.3.2
    • changedInput schema / properties / range / description
      Previous value: -"Range address, e.g. \"A1:D10\" or \"Sheet1!B2:F2\""New value: +"A cell or range, e.g. \"B4\", \"A1:D10\" or \"Sheet1!B2:F2\""
    • changedInput schema / properties / session_id / description
      Previous value: -"Session ID"New value: +"Session ID returned by create_session (list_sessions shows the open ones)"
  2. First observedv0.3.1

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations declare readOnlyHint=true and openWorldHint=false, and the description is consistent with a pure read. Beyond annotations it discloses the 2,000-cell cap, the range_too_large failure mode, that every cell in the rectangle is returned, that unknown sheets or malformed ranges fail the call, and that formula is null for constants/empty cells — exactly the operational limits an agent needs.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loaded with purpose, then format, then return shape, then limits and alternatives — a logical progression with little waste. It is dense but every clause carries information; the return-shape sentence is long but justified given there is no output schema.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no output schema and only two parameters, the description fully covers what an agent needs: accepted input formats, the returned object shape, the cell-count ceiling, and failure conditions. Nothing material is left to inference.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% and the schema already carries the range-format examples, so the description's 'B4', 'Sheet1!B4', 'A1:D10' examples largely repeat structured data. It adds only marginal semantics, such as the rectangle being fully enumerated, which is more behavioral than parameter-level.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Opens with a specific verb and resource: 'Read the formulas and computed values of one cell or a rectangular range in a session.' It also distinguishes itself from siblings by naming get_outputs and trace_dependencies as the tools for adjacent jobs.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicit routing guidance: 'Read a block in one call rather than cell by cell; to read values by defined name use get_outputs, and for the cells that feed one use trace_dependencies.' Both the preferred usage pattern and the alternatives are stated outright.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.