Help Centre › Building Processes
This article describes the RPA Excel functionality to rename columns.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Rename columns function allows you to rename columns.
Setting it up
To use the EXCEL Rename columns function, follow these instructions:
{{popups:rpas/add:action=excel-rename-columns}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Rename 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 Rename columns option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Old name / New name pairs | Yes | Table | - | Pairs of current column names and new column names |
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 |
| Column not found | One of the old column names does not exist |
Tips
- Only the header row is changed, data remains intact