In this section, we will read the input data from the RPA challenge Excel file and store it in a data table. We will use the data in the data table to iterate and input the data into the RPA challenge website. Let's start by opening the Excel file:
- Search for Excel Basic in the Action panel to look up the Excel actions. Add the Open Excel action to open the input Excel file. Let's add the following properties:
- Set Session name as S1.
- Browse and select your RPA challenge Excel file.
- Select the option to open it in Read-only mode.
- Check the Sheet contains a header option:
- Add the Get multiple Cell action to capture the Excel data into a Data Table variable. For this action, set Session name as S1 and Loop through as Specific rows (inputting 1 for From row and 11 for to row) and create a Table variable called excelTable in the Assign value to the variable (optional) field, as shown:
- Finally,...