Filter Table in excel data tables


Has anyone been able to work with the “Filter Data Table” activity?

When I try to use it, following this page explanation:

The activity still gives errors.

Please have a look at the workfile. (Create a folder call “Data” and put the Excel into that folder)
TestData.xlsx (8.1 KB)
data table text.xaml (9.7 KB)


This is working as expected, you just have to be careful about DataTypes while filtering.

Have a look at attached sample and let me know you if this helps

Main.xaml (10.6 KB)

Cool! It works!

Thanks a lot for the help!

Hi Prankurjoshi,

I did as per your sequence from main.xaml and i am trying to load the filtered output to an excel but for some reason i am stuck with an error .

Can you please have a look and let me know where i am going wrong ?
Attachment is below

VishnuWorking with filter.xaml (10.2 KB)
sampleout.xlsx (7.9 KB)

Never mind…I recreated again following your xaml and it worked.


Hi Aksh,

In response to above quoted text, I have a use case.
I have a Table in which the column has text in red font and black font. I usually filter the Table using “Sort by color - RED” in Excel. How would this activity take place in UiPath? What would I put in ‘Filter Options’ in the Filter table activity?


@aksh1yadav From where did you get the table name as you mentioned “Table3” in table name field in filter activity.

Could you please tell. what is “TABLE” here??

Hey @Manchikanti_Abhinay and @khan

TableName - The name of the table that you want to filter.

See the attached screenshot for more clarity. if more then 1 table just click on table and get name.