I have a excel file where i have data of dates listed, using those dates i want to extract Fx rates from web portal for all the dates, basically dates are 1st to last day of the month.
So, i want bot to take dates one after one from excel file and from the web portal collect the data for that date and paste it in excel file and repeat the steps for remaining dates as well.
The web portal looks like this where there is no option for type into.
Thank you for your response, I went through the thread but i didn’t work for me, i was trying to automate this in a way where bot will select two currency e.g GBP to USD
than it will select the date and once after date selection amount pop up in the field it should copy it and paste in excel file in front of that date and so on for other dates.
so far i am able to select currency and type rates, but how to instruct bot to select date from excel file here i’m struggling, please see the below images and advise. Thank You !!
Read the excel file using Workbook or Excel Activities
Store the value in a DataTable variable called dtInput or whatever name you prefer.
Use For Each Row in Data Table activity to loop
Use CurrentRow("DATE").ToString or use formatted value → DateTime.ParseExtract(CurrentRow("DATE").ToString,"MM/dd/yyyy").ToString("RequiredDateFormat')
Extract the value from webpage and store it in a string variable strValue
Use Assign – > LValue = CurrentRow(GBP) = strValue
After the For Each Row in Data Table activity, write the results back to excel using Workbook or Excel Activities.
Hope it helps, Happy to connect over a call as well.
