| 利用VB实现WinCC归档数据处理 |
| |
| 引用本文： | 段培永,王玉红,李慧.利用VB实现WinCC归档数据处理[J].计算机系统应用,2013,22(10):139-142. |
| |
| 作者姓名： | 段培永 王玉红 李慧 |
| |
| 作者单位： | 1. 山东建筑大学 信息与电气工程学院，济南 250101; 山东省智能建筑技术重点实验室，济南 250101
2. 山东省智能建筑技术重点实验室,济南,250101 |
| |
| 基金项目： | 国家自然科学基金(61074070) |
| |
| 摘 要： | WinCC是一款功能强大的HMI系统，它可以组态界面并可以对数据进行归档，但是对于一些复杂的数据处理如数据查询，计算和统计，就显得力不从心．文章利用VB编程工具建立了WinCC的归档数据库与Access数据库和EXCEL的连接，并生成了．exe文件，通过WinCC的直接调用，实验人员可以根据自己的喜好去选择数据存储方法和路径，实现数据的有条件查询和复杂处理．
|
| 关 键 词： | WinCC归档数据 查询 Access Excel |
| 收稿时间： | 2013/3/20 0:00:00 |
| 修稿时间： | 5/8/2013 12:00:00 AM |
Realization of WinCC Archive Data Processing by VB |
| |
| DUAN Pei-Yong,WANG Yu-Hong and LI Hui.Realization of WinCC Archive Data Processing by VB[J].Computer Systems& Applications,2013,22(10):139-142. |
| |
| Authors: | DUAN Pei-Yong WANG Yu-Hong and LI Hui |
| |
| Affiliation: | School of Information & Electric Engineering, Shandong Jianzhu University, Jinan 250101, China;Shandong Key Laboratory of Intelligent Building Technology, Jinan 250101, China;School of Information & Electric Engineering, Shandong Jianzhu University, Jinan 250101, China;Shandong Key Laboratory of Intelligent Building Technology, Jinan 250101, China;Shandong Key Laboratory of Intelligent Building Technology, Jinan 250101, China |
| |
| Abstract: | While WinCC is able to configure interface and archive data as a powerful HMI system, it is inadequate for complex data processing such as data query, computing and statistics. In this paper, the WinCC archiving database is connected with Access database and EXCEL based on VB, then an exe file is generated and can be directly called by WinCC, in which case experimenters can select data storage method and path according to their preferences and accomplish conditional query and complex processing for data. |
| |
| Keywords: | WinCC achiving data query Access Excel |
| 本文献已被 维普 万方数据 等数据库收录！ |
| 点击此处可从《计算机系统应用》浏览原始摘要信息 |
|
点击此处可从《计算机系统应用》下载全文 |
|
