How to read multiple data from an excel sheet in an iterative manner?

You can read excel data in an iterative manner with the help of for loop.

Lets say we have a sample excel file as shown below whose data you want to read one by one.

To achieve this please follow the steps below:

Step 1: Load the excel file using loadexcel function.

Step 2: Set a variable with sequence number to iterate the data one by one and to initialize the variable.

Step 3: Get the number of rows in the excel sheet which will be used in the for loop as the end index.

Syntax: C:\BeatBlip\Sample.xlsx,FilePath,1,H

Step 4: Start for loop with startindex as 0 and end index as total number of rows in the excel sheet. Here it will be ${rowcount}

Step 5: Set the sequence number variable again to be iterated inside for loop.

Step 6: Define a variable and use getsetvalue function to get the data from the excel sheet.

Here, excel data will be picked and will be stored in a variable data defined in Element Key. In each iteration of for loop one by one data will be picked and will be stored in the same variable.

After this you can apply your business logic to use this data.

Step 7: This step will mark the end of for loop.

So the complete test case will look as below:

To know more about the specific functions used in the above use case please refer this link.


Was this page helpful?