How to apply excel filter

Help StudioX
,
1

Hi All,

I need some help on how to filter on column O in Excel and remove Netting

Thank you in adance

Forum Engagement Daily Reports
2

@chai01,

Use Filter activity.

Thanks,
Ashok :slight_smile:

3

use filter data table activity after read the excel

4

@chai01,

You can refer this thread also.

5

Hi,

I have added the filter activity and filled in the source and column name but I need help on how to configure filter so it read the column name, applies filter and remove netting from the list

6

Hi @chai01

Can you try like below

The image depicts a sequence of steps in an Excel automation process, including using an Excel file, applying a filter to a column in a specified sheet, and deleting all hidden rows from the sheet. (Captioned by AI)
The image depicts a sequence of steps in an Excel automation process, including using an Excel file, applying a filter to a column in a specified sheet, and deleting all hidden rows from the sheet. (Captioned by AI)559×676 21.2 KB

A filter window with options for basic or advanced filters is displayed, with parameters set to exclude the value "Netting". (Captioned by AI)

Regards,

7

Hi @lrtetala,

Thank you for your quick response! :slight_smile:

I don’t want to delete any rows I would like the BOT to apply filter on Column O and untick Netting from the list.

sorry for the misunderstanding

8

@chai01,

Kindly share sample input and expected output files for more understanding on this.

9

@chai01

Try like below it will get all data except Netting from the list

The image shows a process workflow for filtering data in an Excel file titled "Excel1.xlsx" within an automated task. (Captioned by AI)
The image shows a process workflow for filtering data in an Excel file titled "Excel1.xlsx" within an automated task. (Captioned by AI)597×699 20.9 KB

This image shows an advanced filter setup where the user is specifying a condition that excludes items with the value "Netting." (Captioned by AI)

Regards,

10

It says column does not exist. I have used the same name in column O in column name

11

@chai01

You need to give your column name
If possible can you share your excel screenshot
Regards,

12

Got it to read the column name.

The BOT applied filter to Column O. However, it unticked all boxes and that was the end of the process

Sorry I am not too sure if I can screenshot the input file as it is work related :confused:

13

@chai01 Hey try to pass filter by linq

You can pass the query and get result data table
What are the conditions for filter ?

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.