We will start by reading the SO data from Excel and storing it in a data table variable.
Just as we used sequences in UiPath to logically separate a sequence of activities, we will use Step activities in Automation Anywhere. We'll add our first Step activity for these Excel activities.
Within this Step, we will add two commands to open and read Excel data:
- Add the Excel basic: Open action to open the input Excel file. Let's add the following properties:
- A Session name of S1.
- Choose the Desktop file option and then Browse... and select your SO Excel file.
- Open in Read-write mode.
- Check the sheet contains a header option:
- Add the Excel basic: Get multiple cells action to read and store the Excel records in a data table variable.
- Add the properties for this action as Session name: S1 and Loop through: All rows, and create a variable of type Table called excelTable and use it in Assign...