worksheet_transfer
Copy data ranges or entire sheets across workbooks, merge multiple workbooks, or stack sheets vertically. Consolidate Excel data from different files into a single destination.
Instructions
Cross-sheet and cross-workbook copy/merge/stack operations.
Args: action: "copy_range_across", "copy_sheet_across", "merge_workbooks", or "stack_sheets". file_path: Source workbook path (varies by action). source_sheet, source_range: Source identifiers for copy. target_sheet, target_start_cell: Destination identifiers. copy_values, copy_styles: Copy options. source_file, dest_file, dest_sheet_name: For copy_sheet_across. source_files, output_file, conflict_strategy: For merge_workbooks. sheet_names, dest_sheet, include_header, output_path: For stack_sheets.
Returns: str or dict: Result metadata.
Notes: - These operations can be expensive (many file opens) and destructive. Document conflict resolution strategies.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| dest_file | No | ||
| file_path | No | ||
| dest_sheet | No | ||
| copy_styles | No | ||
| copy_values | No | ||
| output_file | No | ||
| output_path | No | ||
| sheet_names | No | ||
| source_file | No | ||
| source_files | No | ||
| source_range | No | ||
| source_sheet | No | ||
| target_sheet | No | ||
| include_header | No | ||
| dest_sheet_name | No | ||
| conflict_strategy | No | rename | |
| target_start_cell | No | A1 |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |