Looping through directories

studio

#1

Hello,

I had a foder named “myfolder”:

it contain many forders:

AA
BB
CC
DD
EE
FF
GG

each folder contain an xlsx file

i want to open each xlsx file with excel applicarion scope

is there a way t loop through directories??


#2

@abdel First Read all Files From Folder->Than use For each Loop inside use excel application scope and use counter


#3

in Myfolder i had folders not files, and inside folders there are files


#4

@abdel you can get sub folders also from folder


#5

Hello!

Try something like this: LoopDirectories.xaml (9.0 KB)

Hope it Helps!

Regards,


#6

many thanks,

i had now to do the sum of the one colomn of each slsx, and then store the value in a datatableextaction sum.xaml (22.7 KB)

i did not know where to store it.

VERY URGENT


#7

@abdel Check attached file is useful as per your requirement

ReadFiles.zip (392.8 KB)


#8

thank you indra,

now i’m thinkiing about how to put the result in a datatable,

i’m building a datatable as you may see,

in your workflow can you build a datatable and put the sum in one column (one after the other)