How to create the workflow that opens Excel, reads data from it, then go to a website that calculates and generates BMI and paste it back to Excel onto Column D then send email of the respective BMI results to respective email addresses?
Hello welcome to the community,
Please show us the excel and the fields to be logged in on your site. But the flow you specified
1- Excell Process Scope
Use Excel File
Read Range
2- Assign
SumBMI = (From d in dtData.AsEnumerable
Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim))
Select v = CDbl(d(1).toString.Trim).Sum(Function (x) x)
…
Hie @Raymond_Lim
to create this type of flow
1- use read range -that read the data and save into a data table variable- as dt1
2-then use for each row- to itreate data from the excel row one by one
3-open that Bmi website use open browser activity and pass the link into the activity
4- after calculate use get text to store the calculate data use write cell activity and increament it with the num to update data everytime into the next cell
cheers Happy Automation
ashokkarale
mkankatala
hrkppp
takehiro.ichikura
RPANovice1
adi.mehare
manasrlenka25
Frederik_Krogh
Ankit_Chauhan
ruchirmahajan