Skip to main content
Glama

Write cells to a range

update_excel_range

Overwrite the cells in a range. Whatever is there is replaced without warning, so read the range first if you need to keep any of it. Values are interpreted as if typed.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
rangeYes
sheetYes
valuesYes
mailboxYesEmail address of the connected Outlook/Microsoft 365 mailbox to act on. Call list_authorized_mailboxes to see available options.
workbookIdYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4/5.0
Behavior5/5

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

With no annotations provided, the description carries the full burden of behavioral disclosure, and it does so well. It explicitly warns that existing cell contents are replaced without warning, advises reading first, and clarifies that values are interpreted as if typed. This covers the destructive nature and input semantics clearly.

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

Conciseness5/5

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

Three tightly written sentences with no filler. The core action is front-loaded, the destructive warning is immediately actionable, and every sentence contributes to safe and correct invocation.

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

Completeness3/5

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

The description covers the key operational context for a simple overwrite operation, but given no annotations, no output schema, and five required parameters, there are meaningful gaps: parameter formats for workbookId/sheet/range are not explained, and alternatives are not routed. It is adequate but not fully complete.

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

Parameters2/5

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

Schema description coverage is only 20%, with only 'mailbox' documented in the schema. The description adds useful meaning for 'values' ('interpreted as if typed') and 'range' ('cells in a range'), but it does not compensate for the undocumented workbookId, sheet, range format, or values structure in a way that would let an agent reliably construct all parameters.

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?

The description uses a specific verb ('Overwrite') and a clear resource ('cells in a range'), and the behavior is sharply distinguished from sibling tools like append_excel_rows, read_excel_range, and clear_excel_range. An agent can immediately tell this is a replacement write, not a read, append, or clear.

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

Usage Guidelines3/5

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

The description gives a useful precondition: 'read the range first if you need to keep any of it,' which implies this is destructive. However, it does not explicitly state when to prefer this tool over alternatives such as append_excel_rows or clear_excel_range, so usage context is more implied than stated.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources