I have 12 excel files and i need to make the robot extract alone one single file from all

hello.
i’m new in uipath,and also not sure where can i put my question on,so i have 12 excel files and i need to make the robot extract alone one single file from all, witch activity can i use?

1 Like

Can you extract using the file name? And when you say extract I am guessing you mean using that file under “excel application scope”.

I am a little confused if I understand your question correctly.

1 Like

A colleague of mine just read your question and he is guessing that you might be looking to combine all the 12 files into 1 excel file. Is this correct?

1 Like

Hi @ruki

Welcome to UiPAth :slight_smile:
Can you please explain your question more. Do you want to extract data based on filename?

1 Like

exactly … that’s what i want to do :slight_smile:

1 Like

this is your solution, please try it and let me know if it works.

1 Like

so i don’t know if i explained very correctly… i need to make a robot that will read the folder ( in the file are 12 excels ) and after it makes this … the robot need to read all . i have an patter/model of excel and the robot need to pick the right one after he reads all, to fill the dates inside it … hope i explain ok !

1 Like

@ruki for this you can do like this buddy.Main (3).xaml (9.6 KB) have a look at this buddy,this might be useful.

1 Like

i made it,thank u all.

1 Like

how did you make it? Could you please share?