Help Centre › Building Processes
This article describes the RPA Excel functionality to paste into a cell / range.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Paste into a cell / range function allows you to paste into a cell / range.
Setting it up
To use the EXCEL Paste into a cell / range function, follow these instructions:
{{popups:rpas/add:action=excel-paste-cell}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Paste into a cell / range 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 into a cell / range option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet. |
| Cell | Yes | Text | – | Target cell reference to paste into. |
| Variable | Yes | Text | – | Variable containing the data to paste. |
| Paste type | Yes | Select | All | What to paste: All, Values, Formulas, Formats, etc. |
| Transpose | No | Boolean | Off | Transpose rows and columns when pasting. |
| Unique only | No | Boolean | Off | Paste only unique values. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Cell not found | The target cell reference is invalid. |
Tips
- Use 'Values' paste type to remove formulas and keep only the calculated values.