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

针对当前Windows系统下变电站自动化系统报表软件开发中存在的多方面要求难以兼顾的问题,提出基于微软活动文档(ActiveX Document)技术无缝集成Excel组件的开发技术方案.论述了该方案中要解决的EXcel组件对象访问、用户界面的整合及控制、命令传递、事件拦截处理、预览和打印、文档存储、历史数据访问等关键问题.在多个电气化铁路供电自动化系统报表软件项目中的应用,证明该技术方案是可行和高效的.

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

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 automati...