Help Centre › Building Processes
This article describes the RPA Excel functionality to extract data.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Extract data function allows you to extract data.
Setting it up
To use the EXCEL Extract data function, follow these instructions:
{{popups:rpas/add:action=excel-extract}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Extract data 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 Extract data 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 to extract from. |
| Variable | Yes | Text | – | Variable to store the extracted data. |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Table/Array | The extracted data from the sheet. |
Errors
| Error | Description |
|---|---|
| Sheet not found | The specified sheet does not exist. |
Tips
- The extracted data is stored as a table in memory. Use loop-excel to iterate through it.