节点文献
Excel与数据库间基于语法规则的数据交换技术
Grammar Based Data Exchange Technology Between Excel and Database
【摘要】 针对目前Excel与数据库间的数据交换方法通用性不够的问题,对Excel表单中各逻辑子表的关联关系,以及Excel、应用程序、数据库表三者之间的关系进行了分析,提出了基于语法规则的通用数据交换方法。通过设计一套用于数据交换的语法规则,然后建立解释器解释该规则,便可完成他们间的双向数据沟通。应用证明,该方法具有很好的通用性。
【Abstract】 In this paper, the relationships between the logic sub-tables of the Excel sheet, the relationships among Excel, application, and database tables are fully analyzed. In order to solve the problem of inadequacy in general-utility for data exchange between Excel and database at present, then a grammar-based data exchange solution is presented. The data exchange between Excel and database can be accomplished. By defining a set of grammar rules used for data exchange, and designing a interpreter to explain these rules. In practice, this solution shows good utility of generality.
- 【文献出处】 微电子学与计算机 ,Microelectronics & Computer , 编辑部邮箱 ,2008年01期
- 【分类号】TP391.13;TP311.13
- 【被引频次】4
- 【下载频次】166