基于xml的excel数据加载实现.doc

‘ 摘 要 随着计算机技术的迅速发展和数据加载的广泛应用，基于XML的EXCEL数据加载实现成为录井公司小队人员对井口数据记录加载起到了很大的作用。 基于XML的EXCEL数据加载实现是开发井数据库建设项目中的一个重要的模块，目的是由用户利用EXCEL表格录入数据并通过XML模板将数据导入到数据库，减少了用户对数据库的操作工作。本课题要求建立基于XML的EXCEL数据加载实现的工具，其中包括建立用户界面、EXCEL表格、xml模板。本数据加载工具与已往的数据加载工具最本质的区别是用户根据需求定制EXCEL表格，通过XML模板的映射将数据读出，从而将数据导入到数据库。彻底改变用户直接对数据库直接操作的理念。通过EXCEL的可视化的界面，使数据更加直观的呈现，改善用户的使用体验。本课题应用delphi编程对xml的解析实现功能。 关键词：数据加载实现；数据库；EXCEL表格；XML模板；delphi编程  Abstract Prepare a data with the fact that the computer art promptness develops adding the extensive use being loaded with , become the record well company team personnel owing to that the xml excel data loading comes true getting up to the mouth of a well data precis writer loading having arrived at big roles. Owing to that the xml excel data loading comes true is that the data base developing a well builds a important module in project,purpose has been the data base and data leading-in being arrived at by XML form board to be made use of excel table record to enter a data by the consumer , has decreased by the consumer operation job to the data base. The problem demands to build the implement that loading realizes owing to the xml excel data , includes the building-up consumer interface , excel table , xml form board among them. Data loading implement and before data loading implement the nature difference is that the consumer makes the excel table customarily according to need most , data leading-in arrives at a data base by the fact that xml form board mapping a data is read out , will thereby. Direct permutation consumer idea to data base direct operation. Interface passing the excel Visualization, the usage using especially penetrating presentation format of data , improving a consumer is experienced. The delphi programming analysis the problem is applied to xml realizes a function. Keywords: Data loading comes true; Data base; EXCEL table; XML form board;Delphi programming 目录 前言 4 第1章 开发工具简介 5 1.1 Delphi简介 5 1.2 Excel简介 6 1.3 数据库知识简介 7 1.4 xml解析方法简介 8 第2章 系统分