net环境下通用数据管理模块dll设计.docVIP

.net环境下通用数据管理模块dll设计 摘 要 基于Windows操作系统的Microsoft Office办公软件，在微软公司的大力开发与推广下，已经融入我们生活的各个角落。而我们日常生活中常用的三大组件：文字处理软件Microsoft Office Word、电子表格软件Microsoft Office Excel以及演示文稿软件Microsoft Office PowerPoint，更是成为了一个标准。当然，Office还包括其他一些软件，如小型数据库Microsoft Office Access、绘图软件Microsoft Office Visio等。其独特的存储方式和复杂的结构，在让其他人望其项背独领风骚的同时也常常令开发人员和新手感觉无从下手。其中，Excel因为具有强大的数据表现和处理能力以及较低的入门资格，使得其成为最受欢迎的电子表格软件，广泛的应用在各个领域。因此，根据这一情况与实际需求，仔细的研究与分析了在VS2010中使用C# .net对Excel表格数据的操作的方法与原理[1]，COM组件法、OLEDB和NPOI组件。在.net环境下通过对常用的Excel操作的研究，最终将封装成dll（动态数据链接库）以方便其他人的使用。 关键词：Office；.Net；Excel；操作；封装；Dll The Design of Dll for General Data Management Module in .Net Environment Abstract Microsoft Office software, based on Windows operating system, because of the development and popularization of The Microsoft, has blend in our life. And there are three major components in our daily life：The Word Processing Software (Microsoft Office Word)、The Spreadsheet Software(Microsoft Office Excel) and The Presentation Software (Microsoft Office PowerPoint), which have become a standard. Of course, Office also include some other software, like The small database(Microsoft Office Access)、The Drawing software(Microsoft Office Visio) and so on. Its unique way of storing and complex structure, not only become the number one in the World but also bring some difficulties for the developer and the novice. Because Excel perform a powerful data processing ability and lower entry qualification, make it the most popular spreadsheet software, widely used in different field. So, according to this situation and the actual demand, we carefully research and analyze the method and principle of using C# .net to operate the Excel table data in VS 2010,COM components、OLEDB and NPOI components. Research on the Excel operation in the .NET environment, will eventually be packaged into Dll(Dynamic Link Library) to facilitate the other person. Keywords：Office；.Net；Excel；Operation；Packaged；Dll 目 录 TOC \o 1-4 \h \z \u HYPERLINK \l _Toc421200589