files_move_rows_cols
Reorders whole columns or rows: cuts a column/row range and reinserts it at a destination index, shifting the others and adjusting formula/table references (distinct from files_move, which relocates a rectangular block of cells). axis='columns': range and to are column letters (e.g. range 'B:D', to 'H'); axis='rows': range and to are row numbers (e.g. range '2:5', to '10'). 'to' is the index the range lands before. Requires edit permission. Signature: files_move_rows_cols(file_uuid, axis, range, to, 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>",
"axis": "<axis>",
"range": "<range>",
"to": "<to>"
},
"name": "files_move_rows_cols"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | Destination column letter (e.g. 'H') or row number (e.g. '10'). | |
| axis | Yes | ||
| range | Yes | Columns 'B:D' (or single 'B') / rows '2:5' (or single '3'). | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_uuid | Yes | ||
| sequence_number | Yes |