Can you make an excel table that automatically synchronizes with the website? The answer is yes. This is the power query function in Excel.
1. Open the web page
The following page is the official page of China seismic network（ http://news.ceic.ac.cn/ ）。 Whenever there is an earthquake, it will be automatically updated here. Now that we're going to grab it, we need to open this page first.
First, open the web page to be crawled
2. Determine the grabbing range
Set up a query to determine the capture range
3. Data cleaning
4. Format adjustment
After the data is uploaded to excel, it can continue to be formatted. The processing here mainly includes modifying the table style, text size, background color, alignment, row height and column width, adding titles, etc. in a popular way, it means some beautification operations. Finally, we get the following table.
To beautify the form
5. Set the automatic synchronization interval
Set content automatic synchronization
To prevent table format from being destroyed during update
Write at the end
This technique is very practical, especially in the production of some dynamic reports, can greatly reduce the trouble caused by manual extraction. Well, this is a little skill to share with you in this issue, isn't it very useful!
- THE END -
Link to the original text:Pacific computer network