Updating Excel details to Web portal

Help Studio
, ,
1

Hi All,

I have the total amount details of each vendor in the excel sheet.

I have to enter the total amount of each vendor in the web portal … But the Order in web portal differs from excel.

For Example- If vendor Alroko is in 3 rd row of excel. In the web portal, it is in the 10th row.

Can anyone please, Suggest which is the best approach for this.

Please, find the attached screenshot for reference.

Thanks in advance

images2
image3

2

Read the input excel (DT1),
Then, scrape the portal and loop through (DT2),
For each Datatable in DT2,
Match the ID into DT1 and read appropriate Invoice Amt,
Click on each item in web portal and update the value.

This would be my approach. Not sure if it is the best.