CAJ | 학술논문

在石油化工自控工程设计中，要完成大量的I／O卡件分配工作。使用传统设计模式，需要重复录入数据，从而导致工作效率低，容易出错。采用专业软件INtools，虽然能将数据一次录入，重复使用，但软件并不具备I／O卡件分配的功能，必须通过VBA或可视化工作室工具（VSTO）技术进行二次开发来实现。提出采用VSTO技术借助．Net平台开发Excel COM加载项来实现I／O卡件的分配，实践证明该技术的运用能大大提高自控工程设计工作的效率。
재석유화공자공공정설계중，요완성대량적I／O잡건분배공작。사용전통설계모식，수요중복록입수거，종이도치공작효솔저，용역출착。채용전업연건INtools，수연능장수거일차록입，중복사용，단연건병불구비I／O잡건분배적공능，필수통과VBA혹가시화공작실공구（VSTO）기술진행이차개발래실현。제출채용VSTO기술차조．Net평태개발Excel COM가재항래실현I／O잡건적분배，실천증명해기술적운용능대대제고자공공정설계공작적효솔。
During automation engineering design of petrochemical project, large numbers of I/O card list diagrams must be generated. With traditional design mode, too much data must be input repeatedly, which leads to low work efficiency and easy occurrence of mistakes. The problem can be solved by INtools which can retrieve the data from the database and can be used repeatedly. INtools has no function to generate I/O card lists. It has to be realized by secondary development with VBA or VSTO. It is proposed to adopt VSTO technique in virtue of. NET platform to develop the Excel COM to realize I/O card list assignment. It is proved that this technique can improve the design efficiency of automation engineering project.