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

Implementation of Report Generation System based on Excel

针对企业对报表生成系统的需求,提出了一种基于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.