Sorting Excel File in Studio


I need to read a filtered set of rows from an Excel file. How can I do that?

Hi @anshu.khetarpal

You can use Advanced Loop Activity to filter the rows of an excel.

To understand how to configure Advanced Loop using Excel, refer this knowledge base.

One thing to ensure while using Advanced Loop with Excel is that you must have AccessDatabaseEngine installed on your machine.

You can get it using this link