Definition and Usage
The Read data table command is used to read the contents of a specific cell or an entire row from a table.
Parameters Values
Set parameters
Parameters | Description |
Data table | Select a data table that has been imported to RPA |
Read from | Choose to read the contents of the data table by row or by cell |
Row | Please enter a row number(Non-zero integers). Negative numbers are also supported, e.g. -N represents the Nth row counted from the end. |
Save data as | Specify the name of a variable to save the data read from the data table |
Error handling
Parameters | Description |
When error occurs | If an error occurs, the process is terminated by default. You can also ignore the error or retry the current command |
Example
This workflow will import data from an Excel worksheet, read row 1 of the data table, and save the result as a variable titled "row".
Note: A target data table must be designated to use the Read data table command. This data table can either be imported using the Import from Excel Worksheet command or generated in the previous workflow as a variant.