Excel与数据库间基于语法规则的数据交换技术

针对目前Excel与数据库间的数据交换方法通用性不够的问题,对Excel表单中各逻辑子表的关联关系,以及Excel、应用程序、数据库表三者之间的关系进行了分析,提出了基于语法规则的通用数据交换方法。通过设计一套用于数据交换的语法规则,然后建立解释器解释该规则,便可完成他们间的双向数据沟通。应用证明,该方法具有很好的通用性。

Grammar Based Data Exchange Technology Between Excel and Database

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.