J4 ›› 2012, Vol. 11 ›› Issue (4): 18-21.

• 数学与计算机科学 • 上一篇    下一篇

基于.NET平台的Excel报表研究与实现

在MIS系统中,设计一个既要满足系统功能又要符合用户习惯的报表,是MIS系统的重点和难点。在.NET环境下,以在线评教系统为基础,讨论一个基于结构可变的数据源,通过与COM组件通讯,实现了系统与Excel组件无缝连接的动态的中国式报表。   

  1. 临沧师范高等专科学校信息科学与技术系,云南临沧 677000
  • 收稿日期:2011-11-02 修回日期:2011-11-17 出版日期:2012-04-15 发布日期:2012-04-15
  • 作者简介:舒清录,讲师,主要从事数据库开发、WEB开发与应用研究.

On Research and Development of Excel Report Based on .NET Platform

In the MIS system, the design of a report meeting both system function and user's habits is important and difficult. In this paper, on the basis of online teaching evaluation system and .NET environment, a model of structure-based variable data sources is discussed to realize a dynamic Chinese-style report of seamless connection with Excel component by communicating with the COM component.   

  1. Information Techonology Depart, Lincang Teachers College, Lincang, Yunnan 677000, China
  • Received:2011-11-02 Revised:2011-11-17 Online:2012-04-15 Published:2012-04-15

摘要:

在MIS系统中,设计一个既要满足系统功能又要符合用户习惯的报表,是MIS系统的重点和难点。在.NET环境下,以在线评教系统为基础,讨论一个基于结构可变的数据源,通过与COM组件通讯,实现了系统与Excel组件无缝连接的动态的中国式报表。

关键词: 动态报表, 中国式报表, COM组件, Excel报表

Abstract:

In the MIS system, the design of a report meeting both system function and user's habits is important and difficult. In this paper, on the basis of online teaching evaluation system and .NET environment, a model of structure-based variable data sources is discussed to realize a dynamic Chinese-style report of seamless connection with Excel component by communicating with the COM component.

Key words: dynamic report, Chinese-style report, COM component, Excel report

中图分类号: