copy_range
Copies a source range to a target range in a live workbook, including values, formulas, and formatting by default; use valuesOnly to copy only calculated results.
Instructions
Copy a source range to a target range in the live workbook. Copies values, formulas and formatting by default; valuesOnly copies just the results.
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": {
"source": "<source>",
"target": "<target>"
},
"name": "copy_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | Yes | A1 range address to copy from, e.g. "A1:C3". | |
| target | Yes | A1 range address (top-left corner) to copy into, e.g. "E1". | |
| sheetName | No | Worksheet name for both ranges. Defaults to the active worksheet. | |
| valuesOnly | No | Copy only the calculated values, not formulas or formatting. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |