Read Data from Excel files

In this video, you will see:

  • How to define variables and arguments.
  • How to use Excel activities. Along the way, you will see a pattern of Auteros when dealing with external applications like Excel, PDF, etc. The pattern is: first, you will use Open… prefix activity to open the application and save it in a variable, then use this variable in other application activities to do actions, finally use Close… prefix activity to properly close the app so it won’t leak memory.

The Excel file to be used has following data and header: