Excel VBA在SPI二次开发中的应用  

Application of Excel VBA in Secondary Development of SPI

作　　者：康明[1] 梅刚[1] 

机构地区：[1]胜利油田胜利勘察设计研究院有限公司,山东东营257026

出　　处：《石油化工自动化》2011年第6期59-61,共3页Automation in Petro-chemical Industry

摘　　要：针对SPI所生成报告形式相对固定、客户化难度大的问题.提出利用Excel VBA编程自动生成仪表专业报告的解决方法,详细介绍了该方法实现的关键步骤及要点。该方法成功地提取了SPI数据库中的仪表设计数据,并将这些数据按照改计单位的相关模版自动输出为最终仪表设计文件。经过项目的实际应用和不断完善.该软件已经能自动输出仪表索引表、监控数据表、材料表以及仪表电缆表等。实践证明该方式具有灵活性大、可复用性强的优点,可以大大提高仪表设计人员的工作效率。According to the problem of relative fixed and difficult customized report form generated from SPI, one solution is proposed to utilize Excel VBA programming to automatically generate instrument professional reports, key steps and main content of the method are described in details. The method extracts instrument design data from SPI database successfully, and then automatically export into final instrument design documents based on related template of the design unit. After application in actual projects and continuous improvements, this software already can export many instrument design documents, such as instrument index, monitoring data sheet, material sheet and instrument and cable sheet, etc. The practice proves that the method provides advantage of stunning flexibility and strong reusability, and can improve instrument designer＇s working efficiency significantly.

关 键 词：数据库查询语言 实体关系图 自控辅助设计软件 开放数据库互联 二次开发 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]