Reading the RPA challenge Excel data

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:

1. 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:
   1. Set Session name as S1.
   2. Browse and select your RPA challenge Excel file.
   3. Select the option to open it in Read-only mode.
   4. Check the Sheet contains a header option:

2. 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:

3. Finally,...