Filter in excel

Help
1

Good morning ,
I have excel file with unknown data i want enable filter and select one by one and get the data and store in sheets .
image
Can i do this with uipath because i dont find anything like this

2

You can do it directly on excel by using hotkeys
like for filter send hotkey ctrl+shift+l
then by using alt + down u r able to open that filter list.
then u can select those items by adding counter nd loops as your need
so pls check this out just use simple logic and ofc shortkeys for excel

hope it will help you

3

Thank you . You are the best

4

Can i get the list of result from filter ?

5

when you select that particular data then it will show you the filtered one data
then you can copy it nd do the things which u want
pls mark as solution if you are satisfied with the ans
thank you and Happy automation

6

Hi,

You can use Read Range activity to read the data in the excel to a datatable. Then, you can loop through the datatable using a For Each loop, and use a Write Range activity to write them back into multiple sheets…

If you want to filter by certain values before writing back, you can use datatable functions…

Datatable.Select("ColumnName = Value")

Does it work for you…

7

i know this . i ask if can take the filter list like this image and store it to datatable to use in for each loop

8

Yes i understand this and thank you for your answer but my data is unknown how i use the select . I try find the way to take the unique values and after i use select .

1 Like
9

Hi,

This may help… There is an option to remove duplicates in a datatable. So once you extract the data to the datatable, you can use the “Remove Duplicate Rows” item and provide the datatable as the input for that. This will remove all the duplicates an output you with only distinct values…

I think this is the option you are searching for :slight_smile:

Does it work?

10

An other way of doing this. Is read the excel to a datatable. Create a dataview from this table with the wanted columns. Generate back a datatable with the options unique rows.

2 Likes
11

Thanks you all

12

Datatable.Select(“[Your column name] = [The value you want]”)

13

@pavlou_antwnis

If the data is huge in your excel and most of the values in the specified column will be duplicate data, then if you reading entire data table and then applying formulas, it might take more processing time. For such scenarios you can try deleting the duplicate rows in the excel itself and then get the unique values.

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.