getRange
Read cell values, formulas, and formatting
How to use it
getRange is exposed by the MCP Microsoft Office MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the getRange tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
FULL MCP MICROSOFT OFFICE LISTINGOther tools in MCP Microsoft Office (39)
Accept a meeting invitation
Add attachment to event
Add attachment to email
Add a new worksheet
Cancel an event
Close an active workbook session
Create a meeting or event
Create a sharing link
Open a workbook session (persistent or temporary)
Decline a meeting invitation
Delete a worksheet
Download a file
Find optimal meeting slots
Flag or unflag an email
Check free/busy times
List all calendars
Get calendar events
Read file contents
Get file info
List email attachments
Find meeting rooms
List sharing links
Get a worksheet by name or ID
List OneDrive files
List all worksheets in a workbook
Mark email as read/unread
Read inbox messages
Get full email content
Remove event attachment
Remove attachment from email
Remove sharing access
Reply to an email
Send an email
Write file contents
Tentatively accept
Modify an existing event
Update existing file
Rename, reposition, or hide a worksheet
Upload a file