基于XML映射模板实现不规则Excel数据的转换

摘要

The conversion between irregular Excel data and relational database data is a thorny problem to many enterprises and institu-tions in effective application of database. It conducts a research on the XML mapping template-based approach to implement the conver-sion between irregular Excel data and relational database data,which effectively improves work efficiency,simplifies working process,and is able to handle heavy work load. Through practical application of this conversion system to convert irregular data in batches,the efficien-cy has been proved. Furthermore,this conversion system can be widely applied to any database application system,which reflects the sys-tem' s versatility and practicality.%不规则Excel数据与关系数据库数据的转换是很多企事业单位数据库应用系统在有效利用数据时经常碰到的棘手问题。文中研究的基于XML映射模板实现不规则Excel数据与关系数据库数据的转换方法，有效地解决了不规则Excel数据与关系数据库数据转换中存在的低效、繁琐、工作量大等问题。通过实际应用证明，所研究开发的转换系统可以批量转换不规则Excel数据，体现了高效性；并且可以为任何一个数据库应用系统处理不规则Excel数据提供帮助，体现了通用性及实用性。