Traditional Culture Encyclopedia - Weather inquiry - How to use Excel20 10 to query and automatically save weather forecast information?
How to use Excel20 10 to query and automatically save weather forecast information?
Steps/methods
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
- Related articles
- Is Mianyang Qianfo Mountain closed?
- Excuse me, is it convenient for me to travel to Taimushan, Fujian? Do I live near Taimushan Railway Station or Taimushan Tourist Center?
- The circle of friends who punch in the card talks about the quotations of friends who punch in the card.
- Tomb-Sweeping Day's Grave-sweeping Composition
- Xingtai weather
- Air warning level color
- Weather forecast of Huating in Putian
- Poems containing rain
- That landscape composition
- What do you need to prepare for a trip to Tibet? How to play in Tibet?