update-excel-range

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

Medium RISK CLASS

Category Write

Parameters 85 required

Recommended Rate-limitedsee the rule below

Registry record Grade F, identity unverified Pull the record →

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

WHAT IT DOES

What update-excel-range does on Ms 365

AI agents use update-excel-range to create or update resources in Ms 365, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Ms 365 environment.

Parameter	Type	Required	Description
`body`	object	Yes
`address`	string	Yes	Value for the 'address' path segment.
`confirm`	boolean	—	For destructive operations when the confirm gate is enabled (MS365_MCP_REQUIRE_CONFIRM=true; off by default). Set to true only after the user has explicitly app
`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
`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 update-excel-range is rated Medium

An AI agent can call update-excel-range faster than any human can review: one bad instruction and it creates or modifies resources in Ms 365 by the hundred, each call as confident as the last.

Risk signalsAccepts raw HTML/template content (body)

Attacks that exploit this kind of access

RECOMMENDED RULE

The rule that runs update-excel-range 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 update-excel-range, this is the rule to start with:

update-excel-range Rate-limited

update-excel-range stays usable, but capped: an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "update-excel-range": {
      "limits": [
        {
          "counter": "update-excel-range_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL → Instant setup, no code required.

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

FAQ

Questions about update-excel-range

What does the update-excel-range tool do? +

Update an Excel range. 💡 TIP: Set cell values, formulas, or number format on any range — does NOT require the worksheet to be a formal Excel table. Body: { values: [['v1','v2','v3']] } for a single row, or [['a','b'],['c','d']] for multi-row. Use this for append (target the next empty row's address, e.g. 'A172:H172'), update (target a single cell like 'H42'), or prepend-style edits (read existing, concatenate, write back). Number of inner-array values must match the column count of the address. It is categorised as a Write tool in the Ms 365 MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

What parameters does update-excel-range accept? +

update-excel-range accepts 8 parameters: body, address, confirm, driveId, driveItemId, includeHeaders, excludeResponse, workbookWorksheetId. Required: body, 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 update-excel-range? +

Register the Ms 365 MCP server in PolicyLayer and add a rule for update-excel-range: 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 update-excel-range? +

update-excel-range is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit update-excel-range? +

Yes. Add a rate_limit block to the update-excel-range 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 update-excel-range completely? +

Set action: deny in the PolicyLayer policy for update-excel-range. 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 update-excel-range? +

update-excel-range 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

aroflo_create_or_update_record on AroFlo MCP → The MCP Attack Database →

Guides

Govern customer-ops agents →Argument validation →Scoped token →