Remove the Filters from the Excel Using UIPATH

[srinusoft37]

Hi Team,

Could You help me in removing the filters from the Excel using the UIPATH.

I would like to Remove the Filters From all the columns in the Excel Sheet

Thanks

[Gokul001 (Gokul Balaji)]

Hi @srinusoft37

If you have the header selected with filter on, alt+down will show the Filter options so you can navigate with keystrokes. I wonder if you can do that and look for the Search input box or something to check if Filter is on, cause if it can’t find it then it’s not on.

Have a look on the thread

Switch off the Filter in an excel

@keshav, Can you please share me your logic so that i can give a solution for that. meanwhile, I have created one sample workflow with filter the duplicate name in Excel file using if else statement inside For each activity (Without Filter Activity). DuplicateRecordsCheck.zip (213.1 KB) Thanks, Arunachalam.

Regards
Gokul