Research On The Microsoft Excel File Format And Development Of The Corporation's Table Processing Software Based On Component Technology

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.