How to loop Excel Cell values?

Hi Community,

I have an excel sheet having 10 rows of data and one of the excel cell is having two fields(id=1,2 Age=4,5).

Note : No. of values in id and Age may change.

And I have to extract those values and update in the portal in respective fields.
For Example : As Shown below

Can you please help me with the logic.

Any help would be appreciated:-)

Hi @Vaishnav_Tej

So what you need is you need to take each row of data and transforms that into another excel file or need to uploaded in web portal right?

Hi @Vaishnav_Tej

Please find the following workflow:
Test12.xaml (11.9 KB)




Hope this helps,
Best Regards.


Input is excel cell id=1,2 Age=4,5
Output is : Enter id and Age values in respective fields of web page portal.

Fields are displayed in below format

Web Page1
id 1
id 2
Web Page2
Age 4
Age 5

I have to enter values in the web page portal as shown in the above screenshot

Extract values from excel cell and upload respective values in respective fields