Filter excel data directly without storing

[Sirisha_Siri]

Hi

i want to filter data in excel directly based on a condition without storing in any datatable variable. Can anyone help me on this

[ashwin.ashok ((TheCodingTheory))]

Hi @Sirisha_Siri ,

Have you tried this activity yet?

Kind Regards,
Ashwin A.K

[Sirisha_Siri]

Hi @ashwin.ashok

i am not using Studiox. i am using studio. i need to filter a particular column directly in the same excel and perform further activities on it

[Gokul001 (Gokul Balaji)]

Hi @Sirisha_Siri

You can try with Filter activity

@Sirisha_Siri

i am not using Studiox

Filter Activity is also available in Studio

Go the Filter option → select the Show Modern

Have a look on the documentation

https://docs.uipath.com/studiox/v2019/docs/filter-x

Refer to the thread

Using 'Filter' activity from StudioX in Studio - Source field

Hi everyone, I’m using Studio to design a workflow but have tried using an Excel activity from the StudioX group of activities to perform a task. I’m having trouble working out what value I should be populating in the following Source field. It keeps producing an error that an “end of expression expected”. Does anyone have any idea? The Excel spreadsheet I’m trying to filter has a table called ‘Table1’. Appreciate any help! [image]

Regards
Gokul

[Sirisha_Siri]

Hi @Gokul001

i dont have any table created in my excel. i need to apply filter without using table name

[Gokul001 (Gokul Balaji)]

HI @Sirisha_Siri

In Filter Activity

Source → Excel.Sheet(“Sheet1”)

Regards
Gokul

[Sirisha_Siri]

Thanks @Gokul001