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

Analysis and Study on Personalized Web Log Based on Excel Integration

作　　者：聂超[1] 高慧颖[1] 

机构地区：[1]解放军炮兵学院,安徽合肥230031

出　　处：《现代电子技术》2009年第24期66-68,共3页Modern Electronics Technique

基　　金：中国高等教育学会"十一五"教育科学研究规划课题(1006AIJ11200013)

摘　　要：日志记录了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.

关 键 词：集成Excel WEB日志 数据挖掘 VBA 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论]