Automatically Select Excel Files from the Folder

Help Activities
, ,
1

Hi All,

I have a folder in which 5 excel files exist. Through loop activity I want to automatically select the respective file one by one and then process the selected file. Pl. guide how to do that? Pl see the screenshot in which I am selecting the file from Select File Activity but I want to select the files one by one from the folder and execute the whole process for each excel file and exit.

I don’t want to select each file manually.

Many thanks,

image
image960×702 30.5 KB

2

Hi @Dr_Raza_Abidi_PhD

You can try with the below expression it will get the file in array.

ArrStr → Array(String)

ArrStr = Directory.GetFiles(Environment.CurrentDirectory+"\Input\","*.xlsx").Count

You can get the file passing the output like ArrStr(0)

Regards
Gokul

3

Hey @Dr_Raza_Abidi_PhD

Assign a variable in System.string(Array format)

Var = Directory.GetFiles(“Path”,“*.xlsx”) in System string (Array format)

And loop it using for each.

It will find “.xlsx” file and moves to next step

image
image551×545 9.8 KB

4

Thanks @Gokul001 : Could you please more guide where to put this code? In the Assign activity?

5

Thanks @kishorgy7 : I try it and let you know. Many thanks,

1 Like
6

NP Buddy @Dr_Raza_Abidi_PhD … Check and let me know

7

Hi @Dr_Raza_Abidi_PhD

Check out the XAML for reference

FourmTest.xaml (14.5 KB)

Regards
Gokul