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:-)
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?
Please find the following workflow:
Test12.xaml (11.9 KB)
Hope this helps,
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
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