Skip to main content
Glama

get-excel-range-format

get-excel-range-format
Read-only

Retrieve an Excel range's formatting—font, fill, borders, alignment—to interpret cell styling that encodes status or meaning.

Instructions

Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.

💡 TIP: Reads a range's format: alignment, wrapText, columnWidth, rowHeight. Font, fill, and borders are nested and omitted by default; add font, fill, and borders to the $expand parameter to include them in one call. Cell styling often encodes meaning (a fill or font color flagging status such as tentative or reconciled), so expand these to interpret what the cells mean.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
expandNoNavigation properties to inline, e.g. attachments on a message or event. Only navigation properties can be expanded: expanding a non-navigation property such as a message body fails with "Parsing OData Select and Expand failed", and an unsupported value may be ignored rather than reported. Request ordinary fields with $select instead.
selectNoComma-separated fields to return, e.g. id,subject,from,receivedDateTime
addressYesValue for the 'address' path segment.
driveIdYesValue for the 'driveId' path segment. Pass it under the name 'driveId', not as 'id'. Use the 'id' field of the drive object as returned by Microsoft Graph.
driveItemIdYesValue for the 'driveItemId' path segment. Pass it under the name 'driveItemId', not as 'id'. Use the 'id' field of the drive item object as returned by Microsoft Graph.
fetchAllPagesNoFollow @odata.nextLink and merge up to 100 pages into one response. Can return enormous payloads—only when the user explicitly needs a full export. Prefer a small $top first, then paginate or narrow with $filter/$search.
includeHeadersNoInclude response headers (including ETag) in the response metadata
excludeResponseNoExclude the full response body and only return success or failure indication
workbookWorksheetIdYesValue for the 'workbookWorksheetId' path segment. Pass it under the name 'workbookWorksheetId', not as 'id'. Use the 'id' field of the workbook worksheet object as returned by Microsoft Graph.
Behavior4/5

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

Annotations already declare readOnlyHint=true and destructiveHint=false, and the description reinforces this with 'Read-only.' It goes beyond annotations by disclosing that font, fill, and borders are omitted by default and require the $expand parameter, and it explains why (to interpret cell meaning). This adds valuable behavioral detail not captured in structured metadata.

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?

The description is concise: two sentences plus a tip, with the main purpose front-loaded. The tip is actionable and relevant, containing zero fluff. Every sentence earns its place, and the structure is easy to scan.

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

Completeness4/5

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

For a read-only format getter with 9 parameters, the description covers the essential behavioral nuances: nested properties, expansion, and the interpretative value of formatting. It does not detail return format or pagination, but given the absence of an output schema and the read-only nature, it provides sufficient context for an agent to call the tool correctly. A complete picture would explicitly mention that formatting like fill/font colors may convey meaning, which it does, so it is reasonably complete.

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

Parameters4/5

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

While the input schema has 100% coverage with descriptions for all parameters, the tool's description specifically instructs to add 'font, fill, and borders' to the $expand parameter, which is tool-specific and beyond the generic schema description of expand. It also lists concrete properties returned (alignment, wrapText, columnWidth, rowHeight), enriching parameter semantics beyond the raw 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 states the specific verb and resource: 'Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties.' It clearly distinguishes from sibling tools like format-excel-range (which modifies) and get-excel-range (which presumably returns values), making the purpose unambiguous. The read-only declaration further clarifies its role.

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

Usage Guidelines4/5

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

The description provides clear context: it is for reading a range's format, and it gives practical guidance on expanding nested properties (font, fill, borders) and the semantic significance of cell styling. However, it does not explicitly mention when not to use it or name alternatives like get-excel-range, though the purpose is self-evident.

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/A-Impact-Pavel/ms365-mcp'

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