基于CNONIX的XML与EXCEL相互转换技术研究

Study on the Mutual Conversion Technology of XML and EXCEL Based on CNONIX

针对CNONIX标准的特点,提出了一种符合CNONIX标准的XML与EXCEL相互转换的技术方案,解决了CNONIX标准XML格式与EXCEL格式数据无法自动转换的问题。该方案首先将分析CNONIX标准数据元结构,根据CNONIX数据元结构生成XML格式模板和存储CNONIX中英文对照表文件;然后根据中英文对照表将XML格式数据转换成EXCEL数据格式;最后根据CNONIX的XML模板将EXCEL转化成XML数据格式文件。经过对CNONIX标准的XML格式与EXCEL格式文件进行转换测试,实验结果表明该技术方案能将CNONIX的XML格式数据与EXCEL格式数据准确地进行相互转换。

According to the characteristics of CNONIX standard, a technical conversion scheme of XML and EXCEL based on CNONIX standard is proposed, to solve the CNONIX standard XML format and EXCEL format could not be automatically converted the problem. First, the scheme analyses of CNONIX standard data element structure according to the data element of CNONIX standard structure, create a CNONIX XML format template file and a Chinese-English contrast document; and then according to the Chinese-English contrast file, it converts XML format file into EXCEL data format file; finally,based on the XML format template, it converts EXCEL to XML format file. Through to the CNONIX standard XML format and EXCEL format file conversion testing, the results of experiments show that the scheme can be XML format and EXCEL format CNONIX data accurately conversion.