How to Remove Excel Filters using UiPath?

Hi @subhash1 ,

For Removing the Filters in the Excel Sheet, we could go for Modern Excel Activities Filter Activity Specify the Source as Sheet name and Check Clear any Existing Filters like below :
image

However, we will lose the applied Filters and not so sure if we could get the applied filters back unless we know the Filters ourselves.

If we do know the Filters that is to be applied, we could make use of the same Filter Activity to apply the Filters to the Columns needed like below :

If multiple Filters needed to be applied on multiple columns, we would need to use Multiple Filter Activities.

Let us know if this doesn’t help.

1 Like