Main.xaml (36.8 KB)
project.json (1.7 KB)
SampleExcelFile.xlsx (10.0 KB)
First we want to search on google if capital of country , there capital which we can can’t get in selctor. how to get there?! then we need to search for capital of data on timeandDate webside then extract first row from result table on website.
- Read the excel provided.
- Get the capital of each country in each row using Google.
- Get the weather in the capital of the country of each row using the Time and Date website.
- Update the capital, weather, and status column of each row.
With these workflow most of capital we get but some are exception like capital of Bangladesh.how we can get all capital of countries mentioned in pdf.