Skip to main content
Glama

Get Workbook Info

get_workbook_info
Read-only

Retrieve worksheet names, active sheet, used ranges, and visibility from an open Excel workbook to understand its structure.

Instructions

Get worksheet names, the active sheet, and each sheet's used range.

Args: workbook: Workbook name or path (None = the active workbook of the first Excel instance found).

Returns: JSON with sheet names, the active sheet, and each sheet's used range and visibility.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
workbookNo
Behavior4/5

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

With readOnlyHint=true, the safety profile is already known, and the description adds behavioral nuance: the default resolution to the active workbook of the first Excel instance and the inclusion of visibility in the returned data. It does not contradict the annotation.

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?

The description is short and organized with Args and Returns sections. The return list partially repeats the opening sentence, but the added visibility detail and default behavior make the structure worthwhile.

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?

For a one-parameter read-only tool with no output schema, the description covers what the tool returns, how to specify the workbook, and what happens when workbook is omitted. Nothing else is required to call it correctly.

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

Parameters5/5

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

Schema coverage is 0%, but the description fully compensates for the single workbook parameter by stating it is a name or path and explaining the None default. This is precisely the information an agent needs beyond the bare schema.

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 opens with a specific verb-resource pair and enumerates the exact payload: worksheet names, active sheet, and each sheet's used range. This makes its scope concrete and separates it from sibling tools like list_worksheets, which would only cover the first item.

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

Usage Guidelines2/5

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

The description provides no guidance on when to prefer this tool over list_worksheets, get_table_info, or get_range_values. It explains the workbook argument but not the selection context or exclusions.

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

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/trustypangolin/excel-mcp-live'

If you have feedback or need assistance with the MCP directory API, please join our Discord server