I want to remove filter from Excel Table

[Tambe_Chaitanya]

Hi - I want to copy data from one table to another. Before that, I want to remove filter from the table to be able to copy the complete data.
Kindly advise.

• Chaitanya

[ashokkarale]

@Tambe_Chaitanya,

Use Excel Application Scope inside it use Filteractivity.

Check Clear any existing Filter property checkbox.

Refer this solution.

How to Remove Excel Filters using UiPath?

Hello @subhash1 Use Modern excel activity If you are using classic, just follow the below steps to use modern activity Click the Filter option on Activity pannel. Enable the Show modern option [image] Search Excel. Place Excel process scope, within it place the Use Excel file. In which place the filter activity(pass the source range), check on the clear any existing filter [image]

Thanks,
Ashok

[Anil_G (Anil Gorthi)]

@Tambe_Chaitanya

If you use read range it should read all rows unless you visible rows option

Cheers

[adiijaiin (Aditya Jain)]

Hi @Tambe_Chaitanya

Greetings!

You should be able to read everything using Read Range activity, if you’re not able to, please follow what @ashokkarale Suggested in the post, that should do.

Thanks

Happy Automation!

[Tambe_Chaitanya]

This worked for me. Thanks everyone!