|
| 摘要: |
| EXCEL是一种功能强大且简单实用的图文处理软件，作为过程控制信息的报表处理软件具有独到的优点，如将其与某些过程测控设备相结合，则可方便地实现图形化的操作监视界面。介绍了日本OMRON公司推出的的CQM1小型可编程控制器进行串行通信的功能特点及实现方法，同时介绍了EXCEL中用于实现串行通信的MS＿COMM通信控件及用于实现定时功能的IETIMER控件。提供了在EXCEL中将各种控件与内置的VBA语言相结合，从而实现与CQM1的串行通信。最终完成过程信息提取或过程监控的基本方法。 |
| 关键词: Excel 报表处理软件 CQM1 串行通信 ActiveX控件 |
| DOI： |
| 分类号:TP317.3 |
| 基金项目: |
|
| The Implement of Serial Communication with CQM1 in EXCEL |
|
ZOU Yi min
|
| Abstract: |
| EXCEL is a powerful chart and text manipulation software,and easy to use.It has particular advantages at report form management of process control information.The serial communication functions and application techniques of CQM1 mini type programmable logic controller are introduced,which is designed by OMRON.The Active X controls such as MSCOMM and IETIMER are also introduced,by which the serial data transfer and system timing in EXCEL can be implemented.The basic method is brought forward here,it combines VBA language with various Active X controls to realize serial communication between EXCEL and CQM1 for accomplishing process information display and process control. |
| Key words: PLC,serial communication,EXCEL,VBA,ActiveX control, |
