微型机与应用
微型機與應用
미형궤여응용
MICROCOMPUTER & ITS APPLICATIONS
2012年
18期
17-19
,共3页
董世君%薛玮%董爱芹%陈众
董世君%薛瑋%董愛芹%陳衆
동세군%설위%동애근%진음
Excel%Matlab%Excel生成器%无缝连接
Excel%Matlab%Excel生成器%無縫連接
Excel%Matlab%Excel생성기%무봉련접
Excel%Matlab%Excel Builder%seamless connection
为了充分发挥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沒有專門函數處理電力繫統數據等功能的缺陷。
위료충분발휘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.