基于Excel的报表生成系统的实现  

Implementation of Report Generation System based on Excel

作　　者：赵小娟[1] 王才善[1] 

机构地区：[1]兰州交通大学 光电技术与智能控制教育部重点实验室,兰州730070

出　　处：《铁路计算机应用》2012年第4期70-72,75,共4页Railway Computer Application

摘　　要：针对企业对报表生成系统的需求,提出了一种基于Excel的报表生成系统的设计方案。运用Oracle数据库、Excel模板和组件技术,在.NET环境下采用C#语言开发。系统实现了报表管理、报表生成、导出、打印等功能,利用Excel展现不仅满足企业对报表的需求,也方便用户操作和管理。最后给出了该方法在洛阳石化铁路运输调度管理系统报表开发的一个应用实例,证明了该方法的可行性和有效性,并具有很好的推广价值。According to the basic requirements of Report Generation System to enterprises, a solution on Report Generation System based on Excel was proposed .The System was developed in .NET environment by using C# language with Oracle database, Excel templates and component technology .The System was implemented the report management, report generation, export, printing and so on, could not only meet the needs of report to enterprise, but also be user-friendly and management. Finally, it was given an application of this method which was used to develop the report of Railway Dispatching Management System in Luoyang Petroleum ＆ Chemical Corporation, confirmed the feasibility and effectiveness, had good promotional value.

关 键 词：报表生成系统 分层式 报表模板 EXCEL 

分 类 号：U29[交通运输工程—交通运输规划与管理] TP391[交通运输工程—道路与铁道工程]