Is this available to automate this kind of workflow?

Help Studio
, ,
2

Hi @pprin001

Yes it is possible

  1. You can use table extraction to extract all the data as is from the website into a datatable
  2. Read the excel data into another datatble
  3. Run a loop on website datatable(dtweb)(in arguments assign index variable)
  4. Check if the index < dtexcel.rowcount-1
  5. On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can add other conditions
  6. On then side they are matched… on else side they are not matched…
    5.so on else side of first if data is not present on excel so add it

Cheers

2 Likes