I have tried it using Excel Application Scope but it’s getting only one filter on a single column and i want to apply more than one filter on that single column. Anyone help me out. Thank You.
Welcome to the UIPath Community.
Could you please tell more details about the issue.
yourDT.Select("[Column1] = 'Value1' AND [Column1] = 'Value2'...").CopyToDataTable
And also you can use Filter DataTable activity to do this.
You can do this with filter data table activity. Just add the column name and the conditions to filter.
Ya , I got it. Thank you for your help.