基于Excel的电力监控通用报表系统的设计与实现

Design and Implementation of an Excel-Based Universal Power Monitoring Spreadsheet System

中低压电力监控系统是一个实时数据监控系统,要求能根据用户的实际需要制定报表,而其报表系统一般都采用传统的设计方法。这种设计主要存在两方面的问题:一是仅仅可以满足用户的静态需求;二是其设计一般采用开发环境自带的一些报表工具,而这些报表工具一般又只能实现规则的报表定义。本文针对电力监控中传统报表设计存在的这些问题,给出了利用OLE与VBA相结合对EXCEL实现控制的一种面向用户的报表实现技术,使组态人员能定制报表格式和报表内数据元素,最终可以形成满足用户动态需求的各种样式的规则报表和不规则报表。

The Low-Voltage Power Monitoring System is a real-time data monitoring system, which can construct a report following the customers＇ requirements, but its spreadsheet usually adopts the traditional design form. This design mainly has two problems. One of them is that it just satisfies the users＇ static requirements , while the other one is that it usually uses the report tools which belong to the development environments and these tools always realize only the regular report definition. In this paper, we discuss the deficiency of the dissatisfactory dynamic requirements in conventional spreadsheet design, and finally present a customer-oriented technology which can realize Excel control with OLE and Vt3A to actualize the report. And then the users can customize the report＇ s format and data to realize all kinds of regular and irregular reports which can meet the users＇ dynamic needs.