How to get dynamic path of excel

[jnfantasy4]

Hi all,
How to get a dynamic path address of excel file on excel activity for example:
file-010224-01.xlsx,file.010224-02.xlsx…

[mkankatala (Mahesh Kankatala)]

Hi @jnfantasy4

Could you be more specific for getting much clarification.

[Jayesh_678 (Jayesh)]

Hi @jnfantasy4

Use as below:-
FileDirectory =directory.GetFiles(folderPath,“file*”+system.DateTime.Now.ToString(“ddMMyy”)+“*xlsx”)

FileDirectory is the array of string.

If this works for you, please mark it as a solution, so others can refer the same…

Thanks

[jnfantasy4]

and how about with the number of times 01,02,05…0n?

[Jayesh_678 (Jayesh)]

Hi,

To handle this dynamically, I have use * before xlsx.

Thanks

[jnfantasy4]

Hi, It’s not work my file name is test.xlsx

[Parvathy (PS Parvathy)]

Hi @jnfantasy4

Can you share the screenshots what are the formats of your filenames.

Regards

[jnfantasy4]

Hi,
My filename will be look like this.

[Parvathy (PS Parvathy)]

Hi @jnfantasy4

Will the folder contains only .xlsx files? please specify
Input:

If the folder contains only .xlsx files then follow below process:

Hope it helps!!

[jnfantasy4]

oh,thank you very much

[Parvathy (PS Parvathy)]

You’re welcome @jnfantasy4

Happy Automation!!

[Kia1 (Ana)]

Please help,

I have an Excel file “Excel Template” that I want to fill out

1. Column A8 : C1000 will be filled with data from CSV that I have in the CSV folder
2. Columns E1:K10 will be filled with images that I have in the Image folder
3. Column E12 : K20 will be filled with a circle pivot graph obtained from the data in column A8:C100

Once finished it will be saved in a folder and given a name according to Excel “ListAccount” in the “Subaccount” column

The “Excel Template” file will loop according to the data in the “LisAccount” file

How to create a project like the flow above, so that the “Excel Template” file can run well?
Excel Template.xlsx (10.3 KB)
ListAccount.xlsx (9.3 KB)