Then you have to write a macro. Baidu keywords: VB to get the source code of web pages.

There is another way, excel can import data, select a web page and go to your website to get it. If your web page can be imported smoothly, this method is relatively simple.