一种Excel数据到结构化数据的转换方法

A Method to Convert Excel Data To Structured Data

Excel作为Microsoft Office的一部分,已经被广泛应用于各行各业的数据统计,办公电子表格文档处理等,如何将这些数据与关系数据进行统一管理,Excel半结构化数据与结构化数据的集成是前提.本文采用把XML做为中间转换模型的方法,实现Excel数据与结构化数据之间的转换.

Excel is a part of Microsoft Office, which is widely used in data statistics of all trades and processing electronic form documents etc. How to centralize the administration between these data and relation data, integrating Excel semi structured data and structurization data to be prerequisite. In this paper, XML is used as the middle model to realize the conversion between Excel data and structured data.