Filtering data is a very popular functionality in Excel employed for analyzing large datasets. Although Excel already possesses in-built filtering options, this process can be automated using UiPath thus providing you with the benefit of taking up fewer steps and making it easier to complete. This blog post will guide you on how to create a filter in Excel using UiPath, as well as removing a filter and also the application of such a UIPath filter on a DataTable. No matter what your experience level with UiPath is, these tips will let you automate the data processing workflows you work on better.

1 How to Filter Data in Excel Using UiPath

It is a very easy process to filter data In Excel with UiPath and it consists of the simple flow of Excel Application Scope and Filter Data Table. Here lies the summary of the whole filtering procedure:

Step 1: Open Excel Application

• Take advantage of the Excel Application Scope activity to access the Excel workbook where the data under study is stored.
• Concern the Excel Application Scope to designate the path of your Excel file.

Step 2: Utilize Read Range Activity

• Inside the Excel Application Scope, you need to insert the Read Range activity and then drop it from the Activities panel to the Scope to read the data from your worksheet.
• You must make sure that the “Range” property is left empty so that it would allow you to read the full worksheet, and choose to display the data in the DataTable format as well.

Step 3: Apply the Filter Data Table Activity

• With the DataTable at your disposal, employ theFilter Data Tableactivity to extract specific rows that meet your needs.
• TheFilter Data Tableactivity gives you the opportunity to choose the columns to be filtered and set up the filter criteria. For instance:

• Sorting based on value (e.g., a value higher or lower than a specific number).
• Sorting by text (e.g., contains or starts with a specified text).

For instance, you can choose the option to only show rows in the column where sales data is found if the sales amount is more than $500.

Step 4: Write the Filtered Data to Excel

• After you have filtered the data, you can use the Write Range activity to transfer the filtered data either to the existing worksheet or to a newly created one.

2. How to Remove Filter in Excel Using UiPath

Filters in a spreadsheet are not only crucial at times, but are also the reversal ones may be needed for the managing process tasks such as one-off changes and the file necessities be default for checking the untouched version. Here’s how to remove the filters in Excel by using UiPath: kuid exploratory comments.

Step 1: Open Excel Application

• Initiate the process by getting the Excel file opened in the Excel Application Scope activity.

Step 2: Use the Clear Filters Action

• There is an easy way of clearing filters from your Excel sheet, and it is the action, theClear Filtersaction from theExcel Application Scope,that you can use. Besides, the tool does away with each filter of the worksheet that has been set.

Otherwise, in the case you have used filters manually (for instance, via the AutoFilter feature), you can delete them using Green Automation capabilities by programming the Excel VBA activity to run a macro that does that. The VBA code to clear it goes like this:

Step 2: Use the Filter Data Table Activity

• Include theFilter Data Tableaction in your process flow.
• In theFilter Data Tablesettings, clarify the following:

• Input DataTable: The DataTable which you will filter.
• Output DataTable: A fresh DataTable to hold the filtered results.
• Filters: Specify the filter conditions (e.g., filter by column values, numeric conditions, or text patterns) if any.

For example, if you have a DataTable of employee records you can choose the salary column and put in a condition named salary more than $50,000 to show only those who have salary above $50,000.