get-excel-range-format

SERVERMs 365 SOURCE@jo3zik/ms-365-mcp-server

Low RISK CLASS

Category Read

Parameters 94 required

Recommended Allowedsee the rule below

Registry record Grade F, identity unverified Pull the record →

This record as markdown: /tools/jo3zik-ms-365-mcp-server/get-excel-range-format.md

WHAT IT DOES

What get-excel-range-format does on Ms 365

AI agents call get-excel-range-format to retrieve information from Ms 365 without modifying anything. It is typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Parameter	Type	Required	Description
`expand`	array	—	Navigation properties to inline, e.g. attachments on a message or event. Only navigation properties can be expanded: expanding a non-navigation property such as
`select`	string	—	Comma-separated fields to return, e.g. id,subject,from,receivedDateTime
`address`	string	Yes	Value for the 'address' path segment.
`driveId`	string	Yes	Value 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.
`driveItemId`	string	Yes	Value 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 Microsof
`fetchAllPages`	boolean	—	Follow @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 sma
`includeHeaders`	boolean	—	Include response headers (including ETag) in the response metadata
`excludeResponse`	boolean	—	Exclude the full response body and only return success or failure indication
`workbookWorksheetId`	string	Yes	Value for the 'workbookWorksheetId' path segment. Pass it under the name 'workbookWorksheetId', not as 'id'. Use the 'id' field of the workbook worksheet object

Parameters from the server's own tool schema.

RISK

Why get-excel-range-format is rated Low

Even though get-excel-range-format only reads data, uncontrolled read access leaks sensitive information and racks up API costs: an agent caught in a retry loop can make thousands of calls a minute without anyone noticing.

Attacks that exploit this kind of access

RECOMMENDED RULE

The rule that runs get-excel-range-format safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Ms 365, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For get-excel-range-format, this is the rule to start with:

get-excel-range-format Allowed

get-excel-range-format is read-only, so it stays allowed. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "get-excel-range-format": {}
  }
}

ALLOW ONLY THIS TOOL → Instant setup, no code required.

The button opens the PolicyLayer dashboard: create your workspace, connect Ms 365, apply this rule, and every get-excel-range-format call is checked against it from then on.

FAQ

Questions about get-excel-range-format

What does the get-excel-range-format tool do? +

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. It is categorised as a Read tool in the Ms 365 MCP Server, which means it retrieves data without modifying state.

What parameters does get-excel-range-format accept? +

get-excel-range-format accepts 9 parameters: expand, select, address, driveId, driveItemId, fetchAllPages, includeHeaders, excludeResponse, workbookWorksheetId. Required: address, driveId, driveItemId, workbookWorksheetId. The full parameter table on this page comes from the server's own tool schema.

How do I enforce a policy on get-excel-range-format? +

Register the Ms 365 MCP server in PolicyLayer and add a rule for get-excel-range-format: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Ms 365. Nothing to install.

What risk level is get-excel-range-format? +

get-excel-range-format is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit get-excel-range-format? +

Yes. Add a rate_limit block to the get-excel-range-format rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block get-excel-range-format completely? +

Set action: deny in the PolicyLayer policy for get-excel-range-format. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides get-excel-range-format? +

get-excel-range-format is provided by the Ms 365 MCP server (@jo3zik/ms-365-mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

KEEP EXPLORING

More on Ms 365, and thousands of servers like it.

This server

All 194 Ms 365 tools →

Across the catalogue

get_cocktail_by_category on Cocktails RAG MCP Server →get_file_snippet on ACE-MCP →get_torrent_detail on M-Team MCP Server →aiva_get_affiliate on AIVA MCP Server → The MCP Attack Database →

Guides

Roll out MCP under one policy →Data exfiltration →MCP token cost →