copy_range
Copy a rectangular cell block to another location within a spreadsheet. Moves raw values between sheets or positions, overwriting existing destination data.
Instructions
Copy a rectangular block of cells to another location.
Copies raw values only. The destination can be on the same sheet or a different sheet in the same workbook. Existing values at the destination are overwritten.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| source_range | Yes | Range to copy from in A1 notation, e.g. 'A1:C5' | |
| dest_start | Yes | Top-left cell of the destination, e.g. 'E1'. The copied block expands right and down from here. | |
| sheet | No | Source sheet name. Defaults to the first sheet if omitted. | |
| dest_sheet | No | Destination sheet name. Defaults to the same sheet as the source if omitted. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |
Implementation Reference
- The 'copy_range' tool handler, which copies values from a source range to a destination starting cell.
def copy_range( file: Annotated[str, Field(description="Path to the spreadsheet file")], source_range: Annotated[str, Field(description="Range to copy from in A1 notation, e.g. 'A1:C5'")], dest_start: Annotated[str, Field(description="Top-left cell of the destination, e.g. 'E1'. The copied block expands right and down from here.")], sheet: Annotated[str | None, Field(description="Source sheet name. Defaults to the first sheet if omitted.")] = None, dest_sheet: Annotated[str | None, Field(description="Destination sheet name. Defaults to the same sheet as the source if omitted.")] = None, ) -> str: """Copy a rectangular block of cells to another location. Copies raw values only. The destination can be on the same sheet or a different sheet in the same workbook. Existing values at the destination are overwritten. """ wb = load_workbook(file) src_ws = _resolve_sheet(wb, sheet) dst_ws = _resolve_sheet(wb, dest_sheet) if dest_sheet else src_ws min_col, min_row, max_col, max_row = parse_range(source_range) dest_row, dest_col = parse_cell(dest_start) for r in range(min_row, max_row + 1): for c in range(min_col, max_col + 1): val = src_ws.cell_value(r, c) dst_ws.set_cell( dest_row + (r - min_row), dest_col + (c - min_col), val, ) wb.save(file) return f"Copied {source_range} to {dest_start}"