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
You can do this by opening Excel and using selectors.
We are not supposed to use selectors and do Ui Automation in excel automation.
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
What is the challenge in using the Filter Actvitiy. Plz check the doc below.