Extract Data from excel file to another file by filtring specifi Data

Help
, ,
1

Hello all,

I want to Extract data from an excel file by using the filter of “country” by choosing name of country “Morocco” or another country to another file by filtering just one filter on UIPATH, Can you help me please? you can see the Example on the Picture.

filter-example
filter-example406×580 9.83 KB

Thank you in advance.

1 Like
2

Hi @Maroua302,

Welcome to teh Commmunity !!

  1. Take an Excel Application Scope .

  2. Inside the Scope . Take an Read Range Activity and Pass the Sheet Name - This Will output an Datatable for you Say - InputDT.

  3. Take an Filter DatatTable activity and apply filters as shown below

image

  1. outputDT Now have the FilteredRows.

  2. You Can use an WriteRange activity to write this DataTable to other Excel.

–
Mukesh

3

Move Data.zip (18.4 KB)
here you go…
cheers @Maroua302

4

thank you so much, i have found a video of what i need its about filtering Data table.

5

thank you so much, glad to join the Community.

I have found a video with the same method :

i need your help on Something more complicated, if you can help me, i need to copy every Celle “Name” on new file, is that possible?

Thanks in advance,
Maroua

6

As Far as i understand , you need to copy every Cell of the Column “Name” to a new Excel .

So, FilterDataTable activity has this option of output columns.
Let say , you have 5 Rows in the Main Input DataTable and you want to move only the Name Column to a new Excel where Country = “Morocco”

So , Country =“Morroco” Goes in the filter Rows and To keep only 1 Column , use outputColumns Option as shown below.

image

–
Mukesh

7

Hey,

Thank you for your request, i already do that, but i want that every name is paste on new page separately on the same column an save it.

Can you help me on that please?

8

did you checked my sample workflow??

9

hey, no did you post it ?

10

@Maroua302
Yes… he has it posted here…

11

Thanks for your help, but i need to generate a long workbook, this is just an exemple, i have à facture to generate where the is “Name” “Price” and “Type of Payment” i need to filter “Type of payment” like we did with country by a filtre, and not mention this row, i need to copy just data of Name and price and paste it to another workbook where i have name of row so he should look for rows where their is Price and Name and write juste the first “name” of the list then i will save the file and regenerate another until finishing all names , can you help me on that please?