Traditional Culture Encyclopedia - Weather inquiry - Excel shows the weather at that time.

Excel shows the weather at that time.

The weather forecast is always known.

Through the following techniques, you can check the weather forecast of local or any city in the next few days at any time without watching TV, surfing the Internet or downloading the corresponding software: First, go to /forecast/fc06024.php, select a city (such as Beijing), click the "Search" button, select the relevant data in the open window, right-click and select "Copy" to copy it to the Windows clipboard. Start Excel XP again, create a new workbook, select Edit → Paste, and then drag the scroll bar with the mouse to find the smart tag as shown in the figure. Click it and select Create a Refreshable Web Query. In the window that opens, you will find that there are many data blocks on the webpage, which are marked by the yellow right arrow. When you need a data, just click the yellow right arrow with the mouse. Of course, you can also select multiple pieces of data and press Import to import the selected data into the current table. Click the "Options" button in the upper right corner of the window and set it in the "Web Query Options" setting dialog box. It should be noted that in general, it is best to select the "Full HTML Format" option. At this point, the Beijing weather forecast has basically been imported.

Right-click the prepared weather forecast table, select "Data Area Properties", set it in the "External Data Area Properties" setting window that opens, and select all the check boxes. Finally, save it as "weather forecast". Xls "can be placed on the desktop for easy query. So as long as you are connected to the internet, you can see the latest weather forecast as soon as you open the file.