Abstract: With the limited functionality of data automatic collection in Excel, this paper suggests a way to automatically separate data in Excel reports and discusses engine. This engine uses two layer mapping (template maps to template structure tree, and template structure tree maps to XML schema). XML schema and the mapping path of each cell are generated automatically from Excel template. The related XML document which is in accord with template is automatically separated from Excel report data by the Excel data separation mechanism and it will be much easier to collect data from Excel report and be more advantageous to system’s expansion and integration.

Key words: engine, XML schema, template structure tree, data automatic separation

摘要： 针对当前Excel报表数据自动采集的局限性，提出一种Excel报表数据自动分离的方法，并以此为基础进行引擎的研究。该引擎采用两级映射(模板样式到模板结构树和模板结构树到XML架构)，根据Excel模板自动生成XML 架构和映射信息。借助Excel数据分离机制将Excel报表数据自动分离成与模板样式相对应的XML数据文件，使Excel报表的数据采集更加容易，更加有利于系统扩展与集成。

关键词: 引擎, XML架构, 模板结构树, 数据自动分离

CLC Number: 

• TP311.5