How to use Excel20 10 to query and automatically save weather forecast information?

Next, we use the "/weather/" weather forecast page to import weather information.

In EXCEL, click Data-From Website-New WBE Query to open the dialog box.

Enter the web address in the address box.

Check the sign on the left.

Set import location

Set properties

Press OK to get the data.

The data is displayed at the position starting from the cell A 1

Format the cell area where the data is displayed to beautify it.

Final effect