| 基于Excel的报表生成系统的实现 |
| |
| 引用本文： | 赵小娟,王才善.基于Excel的报表生成系统的实现[J].铁路计算机应用,2012,21(4):70-72,75. |
| |
| 作者姓名： | 赵小娟 王才善 |
| |
| 作者单位： | 兰州交通大学光电技术与智能控制教育部重点实验室,兰州,730070 |
| |
| 摘 要： | 针对企业对报表生成系统的需求,提出了一种基于Excel的报表生成系统的设计方案.运用Oracle数据库、Excel模板和组件技术,在.NET环境下采用C#语言开发.系统实现了报表管理、报表生成、导出、打印等功能,利用Excel展现不仅满足企业对报表的需求,也方便用户操作和管理.最后给出了该方法在洛阳石化铁路运输调度管理系统报表开发的一个应用7实例,证明了该方法的可行性和有效性,并具有很好的推广价值.
|
| 关 键 词： | 报表生成系统 分层式 报表模板 Excel |
| 收稿时间： | 2012-04-15 |
Implementation of Report Generation System based on Excel |
| |
| ZHAO Xiao-juan
,
WANG Cai-shan.Implementation of Report Generation System based on Excel[J].Railway Computer Application,2012,21(4):70-72,75. |
| |
| Authors: | ZHAO Xiao-juan WANG Cai-shan |
| |
| Institution: | ( Key Laboratory of Opto-electronic Technology and Intelligent Control, Ministry of Education, Lanzhou Jiaotong University, Lanzhou 730070, China ) |
| |
| Abstract: | 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. |
| |
| Keywords: | Report Generation System layered report template Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《铁路计算机应用》浏览原始摘要信息 |
| 点击此处可从《铁路计算机应用》下载免费的PDF全文 |
|
