get-excel-used-range

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

Low RISK CLASS

Category Read

Parameters 63 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-used-range.md

WHAT IT DOES

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

AI agents call get-excel-used-range 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
`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-used-range is rated Low

Even though get-excel-used-range 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-used-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 get-excel-used-range, this is the rule to start with:

get-excel-used-range Allowed

get-excel-used-range 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-used-range": {}
  }
}

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-used-range call is checked against it from then on.

FAQ

Questions about get-excel-used-range

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

Get an Excel used range. 💡 TIP: Get the smallest range that encompasses any cells with values or formatting on the worksheet. Returns address, values, formulas, numberFormat, rowCount, columnCount. Use this to discover the populated bounds of a sheet before reading or appending — avoids guessing how far data extends. Optional $select to trim the response. 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-used-range accept? +

get-excel-used-range accepts 6 parameters: driveId, driveItemId, fetchAllPages, includeHeaders, excludeResponse, workbookWorksheetId. Required: 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-used-range? +

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

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

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

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

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

get-excel-used-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

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 →