UiPath - Tips

 Reading the first tab of an excel file

Ever wondered how to read the first sheet of an Excel file without knowing the tab name? follow these this steps:

  1. Open an Excel activity.
  2. Add a Scope.
  3. Use the "For Each Sheet" activity to iterate through sheets.
  4. Read the range of the current sheet.
  5. Break

It should look something like this:

Don't forget to fill in the folder path and the range you want to read.

Commentaires