Easy to manage Web site background files with Excel

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

It's been a while since we've been working on a single novel, from the operation of the site, whether the weight or flow, can be regarded as a vivid, because the theme of the site is serialized novels, the content of the site in the process of continuous updating, found a more difficult problem, that is, the site of many novel update progress, With the increase in the number of novels, it is difficult to accurately remember the progress of each novel update. As a webmaster must be updated every day before the operation, first look at the content of the site, click to learn about the site of each novel update progress and the last update time, which to assist in determining which of the several novels should be updated today which chapters.

If you go to the site each time a click will take a long time, the workload is not only large and repetitive, need to explore a way to faster and accurate access to all of the site's novel file information. As a result of each chapter of the Web site novel to the form of TXT file to the server to a certain path fixed folder, and then by the Web site program automatically matching read and presented on the page, so long as can read the folder under all the file attribute information can meet the requirements. Today, I'm going to share the detailed process of using Excel to manage the background files of the Web site.

1. Get file attribute value

File properties include read-only, hidden, and System Properties three, which can be obtained by GetAttr (file path) in Excel, using result=getattr (file path) in VBA, result returns an integer value, This integer value is related to the file properties as shown in the following table:

2, obtain the file related information

File information contains the size of the file and the time the file was last modified. In Excel, you can get the file size using FileLen and filedatetime to get the last modification time.

Take my Site background file management as an example, use the following VBA code to convert and read all the novel txt files stored in the path of the C:\cxbz958\txt folder of the object properties, and the file related information displayed in the worksheet:

3. Run VBA code macros

After the macro for VBA code in Excel runs, you get three property information about all the file names, file sizes, and the last modification time of the file in the folder, and the results are as follows:

4, with the basic functions of Excel Management

Follow the steps above to run read to Excel worksheet, you can make convenient management, such as filtering, sorting and other operations, you can upload the novel chapter TXT file last modified time, file name and other columns for sorting, so as to facilitate the site backstage of the novel document Management, Master the site of each novel to which chapter, the last update time and other information.

The above is I use Excel to the website backstage document statistics Management detailed steps, hoped that has the website document to carry on the statistical management demand the stationmaster to have the help. Article Editor: Ghost blows http://cxbz958.com/A5 starting, reprint please keep address! Thank you!