files_merge
Merges a range of cells into one (keeping only the top-left value, clearing the rest), or splits merged cells back when unmerge=true. Use by_rows=true to merge each row of the range separately (one merged cell per row), and center=true to also center the merged content horizontally. Requires edit permission. Applied through the collaboration server. Signature: files_merge(file_uuid, range, sheet?, unmerge?, by_rows?, center?).
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_merge"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range, e.g. 'A1:D1'. | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| center | No | Also center the merged content horizontally (default false). Ignored when unmerge=true. | |
| by_rows | No | Merge each row of the range separately into one cell per row, instead of the whole range into one (default false). Ignored when unmerge=true. | |
| unmerge | No | Split merged cells overlapping the range instead of merging (default false). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| range | Yes | ||
| merged | Yes | ||
| file_uuid | Yes | ||
| sequence_number | No |