| 利用DDE在EXCEL中实现高炉监控系统中参数所需的复杂计算功能 |
| |
| 引用本文： | 程艳芬,张娟,周旭朋,李雪芹. 利用DDE在EXCEL中实现高炉监控系统中参数所需的复杂计算功能[J]. 河南冶金, 2009, 17(3): 33-34,56 |
| |
| 作者姓名： | 程艳芬 张娟 周旭朋 李雪芹 |
| |
| 作者单位： | 安阳钢铁股份有限公司;安阳钢铁股份有限公司;安阳钢铁股份有限公司;安阳钢铁股份有限公司 |
| |
| 摘 要： | 主要介绍了如何将上位监控软件中无法完成的复杂公式计算,通过动态数据交换(DDE)技术,与上位监控软件建立链接,把数据读取到EXCEL中,并完成复杂公式计算,实现对所要求数据的监控.通过该技术在炼铁监控系统中的应用,提高了监控系统的质量,实现了高炉工艺数字化、标准化操作.
|
| 关 键 词： | 监控系统 Excel 动态数据交换(DDE) |
MAKING USE OF DDE TO COMPLETE COMPLEX CALCULATIONS OF MONITORING SYSTEM DATA IN EXCEL |
| |
| Cheng Yan-fen,Zhang Juan,Zhou Xu-peng,Li Xue-qin. MAKING USE OF DDE TO COMPLETE COMPLEX CALCULATIONS OF MONITORING SYSTEM DATA IN EXCEL[J]. Henan Metallurgy, 2009, 17(3): 33-34,56 |
| |
| Authors: | Cheng Yan-fen Zhang Juan Zhou Xu-peng Li Xue-qin |
| |
| Affiliation: | Anyang Iron & Steel Stock Co.;Ltd |
| |
| Abstract: | This article introduces how to complete the complex formula calculation which is can't be complete by the epistatic monitoring software.It sets up links with the epistatic monitoring software by DDE technology.This method realizes the monitoring of required data by means of reading data to the EXCEL table and completing the complex formula calculation.The application of this technology in monitoring system of ironworks improves the quality of monitoring system,and realizes polytechnic digitized and standard... |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
