write_range
Write a 2D array of values into a spreadsheet region starting from a specified cell, replacing multiple individual cell writes with a single efficient operation.
Instructions
Write a 2D array of values into a rectangular region.
Writing starts at start_cell and expands right and down to fit the data. Prefer this over multiple write_cell calls for efficiency.
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>",
"start_cell": "<start_cell>",
"data": "<data>"
},
"name": "write_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| start_cell | Yes | Top-left cell where writing begins, e.g. 'B2' | |
| data | Yes | 2D array of values (list of rows), e.g. [[1, 2, 3], ['a', 'b', 'c']]. Numeric strings are coerced to numbers. | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |