Unable to detect the element of filter button

Hi, May i know how to detect the filter button in the excel file,as i cannot detect them.

Hi @Poorani_Ramachandran

I think you may be better off from Read Range then use Filter Data Table wizard.

Filter Data Table (uipath.com)

or check this link for multiple ways to filter data table retrieved from excel

Four Ways to Filter Data Tables in UiPath Studio | UiPath

Kah Liang

Hi Kah Liang,
i think its a faster choice to filter from the excel filter table.


You can also use LINQ to filter datatable/excel.

DataTable selectedTable = yourdatatable.AsEnumerable() .Where(r => r.Field(“ColumnName”) = value).CopyToDataTable();