copy_range
Copy a range of cells from one sheet to another or across workbooks, with options to copy values, styles, or paste only resolved values.
Instructions
Copy a range of cells to a destination range (same workbook or across sheets).
Args: file_path: Source workbook path (when copying within same workbook). source_sheet: Source worksheet name. source_range: Range to copy (e.g. "A1:B10"). dest_sheet: Destination worksheet name. dest_range: Destination top-left target (e.g. "C1"). copy_values: If True, copy values. copy_styles: If True, copy styles. paste_values_only: If True, read resolved values and write values (not formulas).
Returns: str: Success message.
Notes:
- May open the workbook twice if paste_values_only is True (read-only pass then write pass).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| dest_range | Yes | ||
| dest_sheet | Yes | ||
| copy_styles | No | ||
| copy_values | No | ||
| source_range | Yes | ||
| source_sheet | Yes | ||
| paste_values_only | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |