How to choose excel each once start automation



Hi everyone,

I have many excel files, after each use automation I want to change the default excel file?



Hi @longnt23,

The requirement you shared is not very clear. But, I think you want to pick up different excel sheets for each iteration of a loop/sequence. The way to go is using dynamic path for the excel file path. Note that there has to be a pattern used in the naming of the excel sheets (Eg: Case-1, Case-2 , Case-3 … Case-n). Assuming these files are placed in a folder named “UseCases” inside the project folder. You can use a loop to iterate from 1 to n and use a Read Range Activity. The wordbook path supplied should be dynamic as shown below:

Hope this helps.

Kudos! :slight_smile:

Nithin Prabhu


Thank Nithin Prabhu!