Help Centre › Building Processes
This article describes the RPA Excel functionality to add columns.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Add columns function allows you to add columns.
Setting it up
To use the EXCEL Add columns function, follow these instructions:
{{popups:rpas/add:action=excel-add-column}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Add columns 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 Add columns option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Columns | Yes | Textarea | - | Column names to add, separated by line breaks |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open before using this function |
| Sheet not found | The specified sheet does not exist |
Tips
- Separate multiple column names with line breaks
- Columns are added to the right of existing data