摘要
随着Excel文件在Web中的大量使用,应用系统对Excel文件的操作越来越多。针对应用程序对Excel文件操作代码复用性低的问题,提出了Excel数据迁移框架的设计。首先对框架进行结构分析,建立框架结构模型,对框架进行对象分析,建立静态模型,然后对框架的具体实现进行介绍。实际应用表明,该框架能屏蔽底层不同数据库类别,能通过接口扩展来满足不同的业务需求,实现应用系统对Excel数据的导入、导出和图表显示,软件达到高度的复用。
With the wide application of Excel files in the Web, there are more and more Excel files operated in application system. For the poor reusability of operation code of applications on Excel files, we put forward the design of Excel data migration frame. First, by analysing the structure of the frame, its model is established in the design ; and by analysing the object of the frame the static model is established as well. Then, we introduce the specific implementation of the frame. Actual application shows that the frame can shield different database categories in the bottom, and can meet different business needs through extending the interface to realise the imports, exports and chart display of the application system on Excel data, so that the software can reach high reuse.
出处
《计算机应用与软件》
CSCD
北大核心
2014年第1期22-25,29,共5页
Computer Applications and Software
基金
湖北省教育厅科研项目(B20128004)