get_used_range
Find the exact data range in an Excel worksheet by specifying the file and worksheet. Returns the used range to refine operations.
Instructions
Get the used (data) range of a worksheet.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_id": "<file_id>"
},
"name": "get_used_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_id | Yes | ||
| worksheet | No |