摘要
Excel广泛应用于数据统计、电子表格处理等,如何有效地解决Excel和数据库间的数据交换是一个关键问题。分析了Excel XML表格文件的格式,研究了异构数据交换的基本原理,Excel数据和MySQL数据库之间互相交换数据的方法,以及采用PHP实现了交换数据。
Excel is widely applied to data statistics, spreadsheet processing etc. It is a key problem that how to effectively solve data exchange between Excel and databases. The article analysed Excel XML sheet file formats, studied the basic principle of heterogeneous data exchange, the method of data exchange between Excel and MySQL database, and implements data exchange written in PHP.
出处
《电脑开发与应用》
2009年第3期51-53,共3页
Computer Development & Applications
基金
广西财经学院科研课题(2005B05)
