Filter a column directly in Excel and save

Help Studio
, ,
1

Hi All,

I need to filter a column directly in excel and save it. Is there a way to achieve this without writing the data to the data tables or creating table in excel?

I can’t use macros as well since I can’t enable macros in “Trust center settings” for security reasons. It’s disabled

2

Hi @Krithi1,

You can do this by opening Excel and using selectors.

image
image423×660 17.6 KB

Regards,
MY

3

We are not supposed to use selectors and do Ui Automation in excel automation.

4

Hi All, any help here?

5

Hi @Krithi1,

Read excel with read range and then apply filtering according to the conditions you want with the filter datatable activity.

Print the filtered datatable to a latest excel

Regards,
MY

6

Hello @Krithi1

What is the challenge in using the Filter Actvitiy. Plz check the doc below.