How to fetch a single record at a time from a excel file input using loop?

Get Help & Discuss Process Studio
, ,
1

I have a excel file which contains 3 records, I need to fetch a single record at a time inside a loop and then perform certain operations on it and then fetch the next record? How can I achieve this?

2

In AutomationEdge Process Studio, to process Excel records one at a time sequentially, you can use the Start Loop and Continue Loop steps.

  1. Read Excel Data: Use the Microsoft Excel Input step to read the records.

  2. Start Loop: Connect it to the Start Loop step and configure it to process one row per iteration.

  3. Process the Record: Add the required steps (e.g., calculations or GUI automation) after Start Loop.

  4. Continue Loop: Add this step after the processing steps to trigger the next iteration and process the next record.

This approach helps ensure that the processing sequence completes for the current record before proceeding to the next one.