Skip to main content
Glama
WilliamSmithEdward

xlide-excel-word-powerpoint-access-office-vba-mcp

Format cells

xlide_format_cells
DestructiveIdempotent

Format Excel cell ranges by applying bold, fonts, fill colors, borders, alignment, number formats, or merging; only specified properties change, preserving other cell formatting.

Instructions

Changes how a range looks: bold and font, fill colour, borders, alignment, number format, and merging. Only what you pass is changed, so each cell keeps the rest of its own format and making a header row bold does not flatten the number formats under it. Colours are RRGGBB or AARRGGBB hex without a leading hash. A number format is an Excel format code such as '#,##0.00' or 'yyyy-mm-dd'; that code is also what decides whether a number is shown as a date. Works on .xlsx, .xlsm and .xlam.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
boldNoBold on or off.
mergeNo'merge' joins the range into one cell, keeping only the top-left value. 'unmerge' splits it back. Empty leaves merging alone.
sheetYesWorksheet name, matched without case.
italicNoItalic on or off.
strikeNoStrikethrough on or off.
verticalNotop, center, bottom, justify or distributed.
file_pathYesAbsolute path to the Excel file.
font_nameNoTypeface, such as 'Calibri'.
font_sizeNoPoints. 0 leaves it alone.
underlineNoSingle underline on or off.
wrap_textNoWrap text in the cell.
cell_rangeYesA1-style range, such as A1:D1, or a single cell.
fill_colorNoSolid background colour as hex. 'none' clears the fill back to no fill.
font_colorNoText colour as hex, such as 'FF0000'.
horizontalNoleft, center, right, fill, justify or general.
border_colorNoBorder colour as hex. Defaults to automatic.
border_styleNoBorder on all four sides: thin, medium, thick, double, dotted, dashed, hair, or none to remove.
number_formatNoExcel format code, such as '#,##0.00', '0%' or 'yyyy-mm-dd'.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.2/5.0
Behavior4/5

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

Building on annotations, the description adds valuable behavior: partial updates preserve untouched formatting ('making a header row bold does not flatten the number formats under it'). It also discloses color syntax rules and that the number format code determines date display. It does not contradict the idempotent/destructive hints, though it could have warned about merge data loss itself.

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 sentences with no filler: the operation is front-loaded, the most important behavioral nuance follows, and supporting conventions (colors, number format codes, file types) are packed efficiently at the end.

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 an 18-parameter tool, the description covers the operation categories, partial-update behavior, color and number-format conventions, and supported file types. The parameter schema and output schema already carry the remaining details, so nothing critical is missing for an agent to call it correctly.

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?

Schema coverage is 100%, so the baseline is 3, but the description adds cross-cutting meaning: hex colors must omit the leading hash, and number_format is an Excel code that also controls date rendering. This is useful shared semantics that apply to several parameters and is not obvious from individual schema descriptions.

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 and resource ('Changes how a range looks') and enumerates the exact formatting operations it covers. This clearly separates it from value-editing siblings like xlide_write_cells by emphasizing appearance, not cell content.

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 intended use is implied by the listed formatting operations and the explicit statement that only passed properties are modified, but it never states when to choose this tool over alternatives such as xlide_manage_conditional_format or xlide_manage_sheet. There is no explicit exclusion or when-not-to-use guidance.

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