files_borders
Applies (or clears) cell borders on an A1 range. sides: which edges — all, inner, outer, horizontal, vertical, left, top, right, bottom, or clear (remove borders). line: line1 (thin, default), line2 (medium), line3 (thick), double, dotted, dashed. color: hex like '#000000' (default black). Requires edit permission; does not change values. Note: re-applying borders that exactly match the existing ones toggles them off. Signature: files_borders(file_uuid, range, sheet?, sides?, line?, color?).
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_borders"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| line | No | Line style (default 'line1' = thin). | |
| color | No | Hex color '#RRGGBB' or '#RRGGBBAA' (default '#000000'). | |
| range | Yes | A1 range, e.g. 'A1:D5'. | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| sides | No | Which edges to set (default 'all'); 'clear' removes borders. | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| range | Yes | ||
| changed | Yes | ||
| file_uuid | Yes | ||
| sequence_number | No |