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.

Excel竟然还有这种操作:自动同步网站数据

First, open the web page to be crawled

2. Determine the grabbing range

Excel竟然还有这种操作:自动同步网站数据

Set up a query to determine the capture range

3. Data cleaning

Excel竟然还有这种操作:自动同步网站数据

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.

Excel竟然还有这种操作:自动同步网站数据

To beautify the form

5. Set the automatic synchronization interval

Excel竟然还有这种操作:自动同步网站数据

Set content automatic synchronization

Excel竟然还有这种操作:自动同步网站数据

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!

Excel竟然还有这种操作:自动同步网站数据

- THE END -

Excel

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