Matlab与Excel接口技术在电力系统数据分析中的应用

Application of Matlab and Excel interface technology in power system data analysis

为了充分发挥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.