Copy or paste cells
xlide_copy_cellsCopies an Excel range to another cell or block, on the same or another sheet, applying Paste Special options and saving the workbook. Use it to duplicate, transpose, or merge data safely.
Instructions
Copies a range to another cell or block, on the same sheet or another sheet, and saves the workbook. Paste Special can select values, formulas, formats, comments, validation, links or other parts; it can also transpose, skip blanks or combine values arithmetically. The destination may hold data, which the paste can replace. Set allow_overwrite=true only after the user agrees to replace it. Formulas and their relative references move as Excel's Copy does. Works on .xlsx, .xlsm and .xlam.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| paste | No | all, values, formulas, formats, comments, validation, link, or another Excel Paste Special kind. | all |
| sheet | Yes | Source worksheet name. | |
| file_path | Yes | Absolute path to the Excel file. | |
| operation | No | add, subtract, multiply or divide; empty replaces. | |
| transpose | No | Turn source rows into destination columns. | |
| destination | Yes | Destination cell or repeatable block. | |
| skip_blanks | No | Leave destination cells unchanged for blank source cells. | |
| source_range | Yes | Source range such as A1:D20. | |
| allow_overwrite | No | Required: the paste may replace data. Set after user agreement. | |
| destination_sheet | No | Destination sheet; empty means the source sheet. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||