How to dump temperatures in excel for each city


#1

Hi Guys,

I have one requirement-> in excel there are two coloumns city (bangalore,hyd,chennai…etc)and weather.I want to update the weather with new values from google values.How to do that .Please help me here.

Thanks and Regards,
Keerthi.


#2

Yes. You can achieve this. Have you started designing the workflow? If not start using the below activities.

Open Browser -> To Open the browser.
Type Into -> To Enter the Search Keyword.
Click -> To Click on Search button
Get Text -> To get the temperate.

Build Data Table -> To build a data table with 2 Columns City & Weather.
Add Data Row -> Store the Values for the city & the output of get text to the row.

Now, Repeat the process from Search to Adding row for each of the city that you want the data for.

Excel Application Scope with Read Range -> Store the DataTable to the specified excel file.

Let me know if it helps.

Thanks,
Rammohan B.


#3

I have done some part…stucking in between :frowning:weather.xaml (13.0 KB)


#4

Hi! We also made a similar workflow with a difference that it took inputs from the user using an input box!
But saves all the data in an excel file…Make some changes and you are very well to go :slight_smile:
Dynamic Temperature Generator.xaml (50.7 KB)


#5

hey @Rammohan91 ,if you have sample can you pls send me .that would be better way to help here


#6

Here is the sample workflow:

GetWeatherData.zip (24.1 KB)

Thanks,
Rammohan B.


#7

Hi @rpadev - Try this one also LiveWetherReport.zip (16.1 KB)

This process will do following steps -
1.Getting the live temperature by city
2.Based upon the temperature it will fill up the cell color(if temp>29 then red else green)
3.Drawing the Pie chart based upon available data.

Regards,
Nitesh