Help Centre › Building Processes
This article describes the RPA Excel functionality to paste sheet.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Paste sheet function allows you to paste sheet.
Setting it up
To use the EXCEL Paste sheet function, follow these instructions:
{{popups:rpas/add:action=excel-paste-sheet}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Paste sheet function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Paste sheet option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Variable | Yes | Text | - | Variable containing the data |
| Autofill formulas | No | Switch | Off | Autofill formulas after pasting |
| Clear excess rows | No | Switch | Off | Clear rows beyond the pasted data |
| Source / Target column mapping | Yes | Table | - | Mapping of source columns to target columns |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Use column mapping to rearrange columns during paste
- Enable autofill to extend formulas automatically