BS系统可视化Office报表创建技术①.PDF

2017 年 第 26 卷 第 2 期 计 算 机 系 统 应 用 B/S 系统可视化Office 报表创建技术① 张 庆, 郑翠芳 ( 中国工程物理研究院 计算机应用研究所, 绵阳 621900) 摘 要: Office 报表技术是开发基于B/S 的企业信息系统的重要内容之一, 但由于 Office 运行平台和环境制约, 在 B/S 系统的应用中一直得不到很好的发展. 本文在研究报表技术的基础上提出了基于 AJAX 的Office 可视化报表 创建模型, 该模型继承和集成了多种传统 Office 报表技术的优点, 利用 AJAX 的异步通信功能, 在客户浏览器端 实现了可视化报表生成过程, 使用户体验得到了极大的改善, 同时解决了传统Office 报表技术存在跨平台和数据 访问安全问题. 本文提出的可视化的异步报表绘制技术为基于 Web 的报表编程实现提供了一种全新的参考模型. 关键词: AJAX; 可视化技术; Office 报表 Visual Office Reporting Generation Technology Based on B/S System ZHANG Qing, ZHENG Cui-Fang (Institute of Computer Application, Chinese Academy of Engineering Physics, Mianyang 621900, China) Abstract: Office reporting technology is one of the important contents when we develop enterprise information system based on B/S. But in B/S system the application can’t get good development due to the restrains of Office’s platform and environment. This paper puts forward a method to create a model based on reporting technology in view of AJAX and this model inherits a variety of advantages of traditional reporting technologies. And through its feature of asynchronous communication, this technology realizes the asynchronous visualization reporting generation process, which greatly improves the user’s experience. At the same time, this model uses AJAX technology to solve the data access security problems which exist in traditional office reporting technology based on ActiveX. The asynchronous-report-drawing technology provides a new model to achieve the report programming based on Web. Key words: AJAX; visualization technology; Office reporting 引言 化报表创建模型, 此模型完美结合了 ActiveX 技术、 Office 报表一直被广泛使用, 在部门之间、单位之 Office 自动化技术、AJAX 异步通讯技术, 实现了性能 间交付的报表形式大部分是 Word 、Excell 格式文件, 优化、体验改善、运行稳定、数据安全等的