作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2010, Vol. 36 ›› Issue (22): 78-80. doi: 10.3969/j.issn.1000-3428.2010.22.027

• 软件技术与数据库 • 上一篇    下一篇

XML数据交换在Office二次开发中的应用

桑银邦a,王成良b   

  1. (重庆大学 a. 计算机学院;b. 软件学院,重庆 400030)
  • 出版日期:2010-11-20 发布日期:2010-11-18
  • 作者简介:桑银邦(1985-),男,硕士,主研方向:可扩展标记语言,数据库;王成良,教授

Application of XML Data Exchange in Office Redevelopment

SANG Yin-banga, WANG Cheng-liangb   

  1. (a. College of Computer Science; b. School of Software Engineering, Chongqing University, Chongqing 400030, China)
  • Online:2010-11-20 Published:2010-11-18

摘要: 介绍基于DOM处理模式下的XML数据交换技术,分析XML文档树节点与结构化数据之间的联系,通过使用平面系统的平面文件来保存XML数据文件,同时利用Office的VBA和宏技术,提出适合非专业软件开发人员进行Office二次开发的XML数据存储和数据交换方法。该方法可用于实现表格的自动限项填写、修改和检查功能,已较好地应用于科研项目申报表的制作中。

关键词: Office二次开发, VBA编程, 可扩展标记语言, 文档保护

Abstract: This paper introduces an XML data exchange technology based on DOM processing model, and analyzes the relationship between XML document nodes and structured data. It uses plane file in plan system to save XML data files, makes use of VBA and macro which Office itself has at the same time. It presents a way of data restore and data exchange that is suitable with for unprofessional software makers developers to complete the redevelopment of Office. The method achieves automatically filling limited items of table, modification and checking, and it is applied to the production of the requisition in the scientific research project.

Key words: Office redevelopment, VBA program, XML, document protection

中图分类号: