【作者】 杨祖龙；

【导师】 吴国平；

【作者基本信息】 中国地质大学 ， 计算机应用， 2003， 硕士

【摘要】 组件技术是解决软件复用，缩短软件编写时间，降低维护成本和实现程序动态升级的最新和最强的方案。微软公司的组件对象模型COM(Component Object Model)是当今比较成熟的软件组件技术之一，广泛应用于其操作系统和应用程序中。在各种大型应用软件开发、分布式计算和三层体系结构开发等前沿领域，COM组件技术也正在被大量应用。 为了能深入地理解COM组件模型的思想，更好地应用COM组件技术，本文首先介绍了组件软件技术的发展历程，接着分析了当前流行的微软组件对象模型COM，主要介绍了COM对象及其标识、COM接口、注册表与COM对象、类工厂、COM库、COM对象的创建过程等COM技术。根据Excel文件内部结构特点，着重分析了基于COM组件模型的OLE和ActiveX等相关技术。 在分析组件技术的基础上，本文结合在北京某软件开发公司实习时所参与的开发项目，对组件技术进行了实践探索工作。重点利用组件技术中的OLE和ActiveX等相关技术，初步分析清楚了Excel文件内部数据结构，并利用微软开发工具Visual C++7.0开发出一个读写Excel文件的组件。该组件已经作为一个模块集成到公司的系统软件中，很好地完成了该公司表格文件与Excel文件的相互转换功能。 本项目所开发出的组件采用的是直接分析Excel文件内部数据结构和存储机制，因此该组件可以获取Excel文件的内部细节，可以方便地对Excel文件内容进行处理。其次，对财务或管理软件开发公司，利用该组件进行二次开发，可以将内部的表格文件和Excel表格文件进行转换，将Excel软件的强大处理功能和公司内部表格软件的特殊性结合起来。这避免了软件公司独立分析Excel文件结构并重新开发相应组件的过程，提高了开发效率。同时，对网络用户，其机器上不需要安装Excel软件，不用配置ODBC(Open Database Connectivity，开放式数据库互连)驱动及VBA(Visual Basic for Applications)语言运行环境，仅需下载该组件即可，因此该组件特别适合采用B／S(Browser／Server，浏览器／服务器)结构的企业应用软件。 由于受到软件保密协议以及著作权的严格要求，本文没有列出软件的详细设计过程、源代码实现，特表示歉意。更多还原

【Abstract】 Component technology is a powerful and new scheme to solve software reuse, shorten programming time, decrease maintenance costs and realize dynamic program upgrade. The Component Object Model (COM) from Microsoft is one of the mature component technologies, and widely used in the Windows Operation Systems and Applications. Now, the COM technology is also largely perfected in the fields of large application software development, distributed compute, three-tier architecture development.In order to go deep into the thought of COM and use the component technology better, this thesis firstly introduces the development course of the component software technology, then analyzes the present prevailing component technology of Microsoft COM, mainly introduces the COM object and it’s identification, the COM interface, the Register table and the COM object, the Class Factory, the COM library, the creation procedure of COM object. According to the inside structure features of Excel file, the thesis emphatically analyzes the Object Linking & Embedding (OLE) and ActiveX technology based on the COM component model.On the basis of analyzing component technology, combining the project of one software company from Beijing, this thesis practices and explores the component technology. Mainly using the OLE and ActiveX technology of component technology, this thesis clearly analyzes the inside data structure of Excel file, and develops a component that can read and write Excel file using Visual C++7.0. As a functional model, this component has been integrated into the company’s system software, well fulfilled the translation function between the company’s table file and Excel file.The component developed by this project, by use of directly analyzing the inside data structure and storage mechanism, can get the inside detail of Excel file, also can expediently process the Excel file content. On the other hand, financial affairs or management software developing company utilize this component to carry on the secondary development, which can finish the translation between Excel file and their own table file. So they can take advantage of the powerful process function of Excel software and the special features of their own table processing software. Taking this measure, the software company avoid analyzing the excel file separately and redeveloping the component. In addition, the network user do not need to install Excel software on their machine, Needn’t configure the ODBC (Open Database Connectivity) driver and the VBA (Visual Basic for Applications) language running environment, what they should do is downloading the component. So this component is especially suitable for the software company which adopt the B/S (Browser/Server) architecture.By the strict request of the security and secrecy of software, it’s a pity that this thesis doesn’t discuss the detail designing process and the implementation of source code.更多还原