Reading the RPA challenge Excel data

We will use the Read Range activity to read the Excel content. Here are the steps for creating the UiPath automation:

  1. In the Try block, add a new sequence called Main Sequence.
  2. We will now read the input Excel file data into the dataTable variable that we just created. Add the Read Range activity and update the properties of the activity:
    1. Click and point on the RPA challenge Excel workbook location.
    2. Add the range to read on the workbook.
    3. Make sure AddHeaders is checked. 
    4. Set Output to a new dataTable variable.

Here is what our workflow looks like so far:

We now have the Excel data stored in the dataTable variable. Let's now iterate on each row and input the data into the forms on the website. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.82.191