get_sheet_dimensions
Retrieve the row and column count of data in a spreadsheet sheet to determine its size and structure for processing or analysis.
Instructions
Get the dimensions of the used range in a sheet.
Returns {"rows": N, "columns": M} where N is the number of the last used row and M is the number of the last used column. Both are 0 for an empty sheet.
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": "<file>"
},
"name": "get_sheet_dimensions"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |