基于活动文档技术无缝集成Excel的通用报表软件开发技术方案  

Seamless integration of Excel for universal report form development based on ActiveX document

作　　者：李鹏[1] 

机构地区：[1]国电南京自动化股份有限公司铁路自动化事业部,江苏南京210003

出　　处：《电力自动化设备》2009年第3期138-142,共5页Electric Power Automation Equipment

摘　　要：针对当前Windows系统下变电站自动化系统报表软件开发中存在的多方面要求难以兼顾的问题,提出基于微软活动文档(ActiveX Document)技术无缝集成Excel组件的开发技术方案。论述了该方案中要解决的Excel组件对象访问、用户界面的整合及控制、命令传递、事件拦截处理、预览和打印、文档存储、历史数据访问等关键问题。在多个电气化铁路供电自动化系统报表软件项目中的应用,证明该技术方案是可行和高效的。For the development of universal report form on Windows platform to satisfy the varied needs of substation automation systems, an implementation scheme to seamlessly integrate Excel based on ActiveX document is proposed. The key problems, such as component object access, UI conformity ＆ control, command routing, event capture ＆ handling, file preview ＆ printing, and archive ＆ historical data access, are discussed. It has been successfully applied in the report software of the electrified railway substation automation system and proved feasible and effective.

关 键 词：通用报表 ACTIVEX文档 无缝集成Excel 变电站 历史数据访问 

分 类 号：TM734[电气工程—电力系统及自动化] TP317.3[自动化与计算机技术—计算机软件与理论]