LabWindows/CVI中Excel报表技术研究  

Research on Excel Report Technology in LabWindows/CVI

作　　者：张海洋 王刚[1,2] 羊新胜 赵勇[1,3] ZHANG Hai-yang;WANG Gang;YANG Xin-sheng;ZHAO Yong(Key Laboratory-of Magnetic Levitation Technologies and Maglev Trains（Ministry-of Education）,Superconductivity and New Energy R ＆ D Center,Southwest Jiaotong University,Chengdu 610031,China;School of Electrical Engineering,Southwest Jiaotong University,Chengdu 610031,China;School of Materials Science and Engineering,University of New South Wales,Sydney NSW 2052,Australia)

机构地区：[1]磁浮技术与磁浮列车教育部重点实验室西南交通大学超导与新能源研究开发中心,四川成都610031 [2]电气工程学院西南交通大学,四川成都610031 [3]新南威尔士大学材料科学与工程学院

出　　处：《测控技术》2018年第8期131-134,共4页Measurement & Control Technology

基　　金：国家自然科学基金资助项目(51271155;51377138)

摘　　要：在测控系统中,虚拟仪器是由模块化硬件配合软件组成的,具有较高的灵活性和扩充性,因此,广泛应用于测控领域。通常测控系统利用ActiveX输出数据报表,该方法较复杂,而虚拟仪器软件开放平台LabWindows/CVI简化了数据报表的输出。详细阐述了用LabWindows/CVI的excelreport.fp仪器驱动访问Microsoft Excel的方法,提出工程中常出现的报表格式相同而报表数不确定的解决方法,针对excelreport.fp仪器驱动不能复制的功能缺陷,提出了解决方法。并通过工程实例验证了该方法,说明其有很高的工程应用价值。In the measurement and control system, the virtual instrument consists of modular hardware and software. With high flexibility and scalability, it is widely used in the field of measurement and control. The measurement and control system usually outputs data report by ActiveX. The method is quite complicated, and the virtual instrument software open platform LabWindows/CVI simplifies the output of the data report. The approach of accessing Microsoft Excel 2003 by LabWindows/CVI excelreport. fp instrument driver is illustrated in detail. The function defect that cannot be copied is found in the excelreport. fp instrument drive. The solution of the defect is given in an Excel data report, which often appears in the projects with the same report format but whose report number is uncertain in advance. The practical engineering verifies this method, which shows that this method is of great value to practical application.

关 键 词：虚拟仪器 仪器驱动 数据报表 LABWINDOWS/CVI EXCEL 

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