Query management Web Forms Excel easy to implement

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Some Web pages to read the principle of the form of the page to show the content of the site, the function can give users intuitive results, but the form content of real-time management is the webmaster feel annoyed piece of content, for webmasters, it is not possible to fully understand the query form every time, The log server will download the corresponding files to the local and then convert to the Statistics tool can read files. Today, I will share the details of how to use Excel to easily implement query management Web Forms in detail.

1, establish a local connection query Web site form data files

The normal way to import Web pages, you cannot see the location of the connection file, even through regular manual import, so you cannot generate and save the corresponding iqy file in this way. To establish a local connection query the iqy file for a Web site form:

Create a new Excel worksheet and open, select data in the menu-Import external Data-new Web query, and pop up the following dialog box:

Enter the page URL of the form that is in the Address bar, and click the Go button to open the page to which the specified form belongs.

Click the form that you want to display, and the Save Query button.

Save the Iqy file for the form data connection to the local path.

2, change the iqy file connection code

Open the iqy file you just saved with a text program, and what you see after you open it is shown in the following image:

In this code, the number following the selection equals sign represents the index number of the form in the Web page, formatting represents the processing of the format type after the form data is imported. Change the "None" attribute of Formatting=none to "all", which means that all formatting is preserved and changes are saved.

3, with local iqy file connection query display form content

Use the following VBA code to establish a connection using the local iqy file and display the content of the form with the index number 3 of the corresponding URL in the local Excel worksheet.

The results of the operation are as follows:

The use of the above method can be real-time convenient query management site forms. This article by the weight loss rankings Net http://www.jianfei1234.com/Original summary, original starting in A5, reprint time please keep the author link, thank you!