How to read all excel in one folder

Help
2

@mashy2

Follow these steps:

  1. String excelFiles [ ] = Directory.GetFiles(“folderPath”,“*.xlsx”)

  2. Above expression will read all Excel files from folder and will give output as String array.

  3. Then use For Each loop Activity to itreate that array of files and use Read Range Activity to read Excel data and use this Activity inside Excel Application Scope Activity.

2 Likes