How to loop Excel Cell values?

Help Studio
, ,
1

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).
image

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
image

Can you please help me with the logic.

Any help would be appreciated:-)

2

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?

3

Hi @Vaishnav_Tej

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

Input:
image

Output:

image

Hope this helps,
Best Regards.

4

Hi,

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

5

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