Help Centre › Building Processes
This article describes the RPA Excel functionality to list all structured tables in a sheet.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL List tables function lists all structured tables in the current sheet. Returns a list of objects with name, display_name, range, style, has_headers, and has_totals.
Setting it up
To use the EXCEL List tables function, follow these instructions:
{{popups:rpas/add:action=excel-list-tables}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL List tables 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 List tables 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. |
| Variable | Yes | Text | – | Variable name to store the list of tables in. |
Output variables
| Variable | Type | Description |
|---|---|---|
| {variable} | List | List of table objects with name, display_name, range, style, has_headers, and has_totals. |
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
| Sheet not found | The specified sheet does not exist. |
Tips
- Use this to check which tables exist before adding or removing tables.
- The returned list includes each table's range, which is useful for further processing.