How to choose excel each once start automation

Help
,
1

Hi everyone,

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

Thank,
Henry.

2

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:

image
image1323×377 52 KB

Hope this helps.

Kudos! :slight_smile:

Regards,
Nithin Prabhu

2 Likes
3

Thank Nithin Prabhu!

1 Like
4

勉強になりました。

1 Like