报表自动生成及其在设备检测系统中的应用  

Automatic report generation and its application in equipment testing system

作　　者：曾倩[1] 袁海文[1] 秦业[1] 

机构地区：[1]北京航空航天大学自动化科学与电气工程学院,北京100191

出　　处：《中国测试》2010年第1期67-71,共5页China Measurement & Test

基　　金：国家863高新技术研究发展计划(2007AA04Z215);航空科技基金项目(2008ZD51060)

摘　　要：针对目前设备检测系统中数据量大,且经常要求以各种报表格式化输出数据信息的问题,分析了VS.NET开发环境下的报表自动生成机制,并提出了适用于两种不同情况的报表生成方法,实现了数据报表的自动生成。在VS.NET开发环境中,利用组件对象模型(COM)来控制外部的Excel应用软件,充分利用计算机强大的数据处理能力,能够实现电力设备检测领域专业报表的生成、编辑、显示和打印等功能。分别以安全阀在线自动调校仪和SF6密度继电器自动校准仪为例,成功将该方法应用于电力设备检测系统中。实际应用表明,该方法具有较强的工程实用性和通用性。In order to solve the problem of large volume of data which generally are required to be reported in formatted form in equipment measurement and testing systems, the mechanism of automatic report generation in Visual Studio.NET has been analyzed, and two different report generation methods have also been presented, through which data reports can be generated automatically. In the development platform of Visual Studio.NET the methods utilize COM to control the external Excel program. With the powerful data processing ability of computer, many functions of professional report such as report creating, editing, display, printing and so on can be realized in power equipment testing field with those methods. Automatic report generation methods have been sucesafully applied in some power equipment testing systems such as automatic tester for online safety valves and the SF6 density relay calibration instruments. The results of practical applications prove that the methods possess strong engincering practicability and universality.

关 键 词：组件对象模型 对象链接与嵌入 报表 EXCEL软件 设备检测系统 

分 类 号：TP274[自动化与计算机技术—检测技术与自动化装置] TP311.52[自动化与计算机技术—控制科学与工程]