基于集成Excel的个性化Web日志分析研究

Analysis and Study on Personalized Web Log Based on Excel Integration

日志记录了Web服务器接收处理请求以及运行时错误等各种原始信息,对日志进行统计、分析,能有效掌握服务器的运行状况,发现和排除错误原因,了解客户访问分布。在此,介绍了集成Excel技术的概况,并利用Office内置的编程语言VBA实现了对Excel的集成,利用应用程序实现了对Excel的操纵,实现了Web数据挖掘的个性化。

Web server log is a record of original information that receiving the request and run -time error, by counting and analyzing the log,operation of the server can be mastered,the wrong reasons can be detected and excluded,the distribution of client access can be understood effectively. The overview of technology of Excel integration is introduced, and programming language VBA in office is adopted to achieve the Excel integration. By using of the application to manipulate the Excel, Web data mining is realized.