files_has_data
Checks whether an A1 range is already occupied — cell values, code/table output, or merged cells (each can cause a spill). Use before placing a table or code cell to avoid spill errors. Returns { has_data: true/false }. Read-only; reflects the file's latest live state. Signature: files_has_data(file_uuid, range, 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_uuid": "<file_uuid>",
"range": "<range>"
},
"name": "files_has_data"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range to check, e.g. 'A1:D10'. | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| has_data | Yes | ||
| file_uuid | Yes |