|
|||||
|
|
| 基于Web服务的Excel智能客户端的应用研究 | |
| 引用本文： | 姜善林,于峰,索红光. 基于Web服务的Excel智能客户端的应用研究[J]. 计算机工程与设计, 2007, 28(10): 2481-2483 |
| 作者姓名： | 姜善林 于峰 索红光 |
| 作者单位： | 1. 中国石油大学,计算机与通信工程学院,山东,东营,257061 2. 北京邮电大学,自动化学院,北京,100083 3. 中国石油大学,计算机与通信工程学院,山东,东营,257061;北京理工大学,计算机科学技术学院,北京,100081 |
| 摘 要： | 针对当前客户端应用模式的不足,结合石油工程造价管理系统的开发,介绍了智能客户端技术及特点,提出了面向服务的Excel智能客户端的解决方案,并以.NET框架为基础设计并实现了在线和离线应用模型.讨论了Web服务的实现、Office内置的XML本地支持、Excel中的VBA编程机制、VBA代理类与Web服务间的通信等系统构建过程中的关键技术,并在此基础之上详细论述了数据处理、数据传输等重要事项.该方案较好地满足了操作简便、界面丰富、离线访问等实际需求. |
| 关 键 词： | 智能客户端 Web服务 面向服务的架构 B/S模式 C/S模式 面向服务 Excel 智能 客户端技术 应用模型 研究 web services based client smart research 需求 访问 界面 操作 重要事项 数据传输 数据处理 构建过程 系统 |
| 文章编号： | 1000-7024（2007）10-2481-03 |
| 修稿时间： | 2006-05-30 |
Application research of Excel smart client based on web services |
|
| JIANG Shan-lin,YU Feng,SUO Hong-guang. Application research of Excel smart client based on web services[J]. Computer Engineering and Design, 2007, 28(10): 2481-2483 | |
| Authors: | JIANG Shan-lin YU Feng SUO Hong-guang |
| Affiliation: | 1. School of Computer and Communication Engineering, China University of Petroleum, Dongying 257061, China; 2. School of Automation, Beijing University of Posts and Telecommunications, Beijing 100083, China; 3. School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, China |
| Abstract: | The deficiencies of current client application pattern are discussed.Through the example of the petroleum engineering make price system's development,smart client and its advantages are introduced.An Excel smart client solution is recommended,the online and offline model are designed and implemented on the basis of.NET framework.Some key technologies to be paid attention to in the implementation of system,such as web services' development,Office embedded XML local support,VBA programming mechanism in Excel,the communication between VBA proxy class and web services component,are discussed.At the same time,some important proceedings,such as data access,data transmission are explained in detail.The actual needs such as simple operation,rich user interface and offline access are fulfilled. |
| Keywords: | smart client web services SOA B/S pattern C/S pattern |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |