CAJ | 학술논문

为了充分发挥Excel和Matlab各自的优势，实现两者之间的无缝连接并将其应用于电力系统数据分析中，简要分析了DDE（Dynamic Data Exchange）和自动化技术、ExcelLink插件以及通过Excel生成器等3种接口技术。而Excel生成器生成插件又有两种方法，通过一个实例重点介绍了其中一种工作量少、简单方便的方法。通过对保存在Excel中的数据进行处理分析，结果显示这种以Excel为载体、Matlab程序集成到Excel插件处理数据的思想能够很好地弥补Excel没有专门函数处理电力系统数据等功能的缺陷。
위료충분발휘Excel화Matlab각자적우세，실현량자지간적무봉련접병장기응용우전력계통수거분석중，간요분석료DDE（Dynamic Data Exchange）화자동화기술、ExcelLink삽건이급통과Excel생성기등3충접구기술。이Excel생성기생성삽건우유량충방법，통과일개실례중점개소료기중일충공작량소、간단방편적방법。통과대보존재Excel중적수거진행처리분석，결과현시저충이Excel위재체、Matlab정서집성도Excel삽건처리수거적사상능구흔호지미보Excel몰유전문함수처리전력계통수거등공능적결함。
The seamless connection between Excel and Matlab applied in power system data analysis is realised to give full play to the advantages of them. Three methods of interface technolog,） are introduced, including using DDE （Dynamic Data Exchange） and Automation technology, Excel Link and Excel Builder. The Add-ins of Excel can be generated by Excel Builder in two ways, the work less, simpler and more convenient method of which is emphasized and is applied in power system data analysis as an example.The result of Matlab programs integrated into Excel as a add-in, which is made as a carrier of data acquired in power system research, shows that it can well make up for the defects of Excel which has no specific data processing functions in power system.