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:
- Open an Excel activity.
- Add a Scope.
- Use the "For Each Sheet" activity to iterate through sheets.
- Read the range of the current sheet.
- Break
It should look something like this:
Don't forget to fill in the folder path and the range you want to read.
Commentaires
Enregistrer un commentaire