本文已被:浏览 1561次 下载 4866次
Received:March 20, 2013 Revised:May 08, 2013
Received:March 20, 2013 Revised:May 08, 2013
中文摘要: WinCC是一款功能强大的HMI系统, 它可以组态界面并可以对数据进行归档, 但是对于一些复杂的数据处理如数据查询, 计算和统计, 就显得力不从心. 文章利用VB编程工具建立了WinCC的归档数据库与Access数据库和EXCEL的连接, 并生成了.exe文件, 通过WinCC的直接调用, 实验人员可以根据自己的喜好去选择数据存储方法和路径, 实现数据的有条件查询和复杂处理.
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
文章编号: 中图分类号: 文献标志码:
基金项目:国家自然科学基金(61074070)
引用文本:
段培永,王玉红,李慧.利用VB实现WinCC归档数据处理.计算机系统应用,2013,22(10):139-142
DUAN Pei-Yong,WANG Yu-Hong,LI Hui.Realization of WinCC Archive Data Processing by VB.COMPUTER SYSTEMS APPLICATIONS,2013,22(10):139-142
段培永,王玉红,李慧.利用VB实现WinCC归档数据处理.计算机系统应用,2013,22(10):139-142
DUAN Pei-Yong,WANG Yu-Hong,LI Hui.Realization of WinCC Archive Data Processing by VB.COMPUTER SYSTEMS APPLICATIONS,2013,22(10):139-142