基于XML的Excel数据提取和集成研究

Excel Data Extraction and Integration Based on XML

异构数据源的集成问题是当前数据处理领域内研究的一个热点,它能更有效地利用信息资源、更好地实现数据共享.针对当前企业对异构数据库中Excel数据源集成的迫切需求,本文提出一个基于XML模板的Excel数据源数据映射方案,能使数据转换更加灵活通用.该方案是实现异构数据源之间数据交换的通用方法,实现了Excel数据向标准XML文件的相互转化,有效提高了整个应用系统的性能.

The integration of heterogeneous data sources is a hotspot in the field of current data processing research which can make effective use of the information sources and share data better. In view of the urgent demand of the current enterprise for integration of Excel data sources in heterogeneous data systems, an Excel data mapping scheme is proposed based on XML template, making the data conversion more flexible and general. The program is an effective exploration to achieve heterogeneous data sources for data exchange between the common methods, and it is also a forceful exploration realizing the data exchange between heterogeneous data sources and bringing the data transformation between Excel data and the standard XML documents into effect, which effectively improve the performance of the entire application system.