Home > News content

Excel even has this kind of operation: automatically synchronize website data

via:驱动之家     time:2021/5/6 9:46:01     readed:114

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!




Link to the original text:Pacific computer network

China IT News APP

Download China IT News APP

Please rate this news

The average score will be displayed after you score.

Post comment

Do not see clearly? Click for a new code.

User comments