JIN Lu1,2, ZHENG Bin1,2, CHEN Chang-xin1,2
(1. Science and Technology on Electronic Test & Measurement Laboratory, North University of China, Taiyuan 030051, China;2. Key Laboratory of Instrumentation Science & Dynmaic Measurement (North University of China),Ministry of Education, Taiyuan 030051, China)
Abstract： This paper proposes a new method that can access the Microsoft Excel 2003 by ActiveX to make up for the limitation of the data report in LabWindows/CVI. It can produce a required data report and draw up a data chart automatically in the testing system by programming. This helps improve the flexibility and universality when producing the data report and increase the efficiency greatly.
Key words： LabWindows/CVI; ActiveX; Microsoft Excel 2003; Excel report
CLD number： TP391 Document code： A
Article ID： 1674-8042(2014)03-0016-04 doi： 10.3969/j.issn.1674-8042.2014.03.004
References
[1] WANG Xiao-gang, WU De-guang. A method of applying the Excel document under LabWindows/CVI environment. Journal of Gansu Sciences, 2013, 25(2): 101-104.
[2] GUO Mei-jun, XU Long-xia, GAO Yuan-yuan, et al. Real-time control software for xPC hard-ware-in-the-loop test platform based on LabWindows/CVI. Journal of Computer Applications, 2013, 33(S1): 259-261.
[3] GAO Yong-qiang, LIU Shu-xia, HUO Xiao-jing, et al. Environment measurement and control system in livestock care based on LabWindows/CVI. Journal of Chinese Agricultural Mechanization, 2014, 35(2): 275-277.
[4] LIU Ting-ting, GUAN Bo. Design and realization based on test system of proportional-valve. China Measurement and Test, 2014, 40(2): 86-89.
[5] WANG Ling, WANG Xin, LIU Jian, et al. Research on flexible remote monitoring system of agricultural machinery based on virtual instrument. Journal of Agricultural Machinery, 2014, 45(1): 34-39.
[6] FU Yong-zhong, YANG Huai, LIU Ming-dong. Development of calibration tool for universal small engine based on LabWindows/CVI. Information Technology, 2014, (1): 65-67.
[7] ZHOU Zi-long, WANG Zhao-feng, WANG Shu-hong. Data acquisition system based on LabWindows/CVI. Electronic Science and Technology, 2013, 26(6): 107-110.
[8] HE Xiang-liang, ZHANG Hong-chang, ZHOU Fan-li, et al. Design and implementation for signal simulation system of hydraulic landing gear in HIL. Journal of Computer Applications, 2011, 31(S2): 190-191.
[9] LI Ting-ting, ZHANG Ren-jie. Design and realization of mobile phone number writing tools based on LabWindows/CVI. Journal of Computer Applications, 2012, 32(S1): 102-104.
[10] WANG Jian-xin, SUI Mei-li. Advanced application in virtual instrument based on LabWindows/CVI. Bei Jing: Chemical Industry Press, 2013.
[11] GUAN Ting-ting, ZHAI Zheng-jun, JIANG Hong-mei. Design and implementation of universal control system report based on Labwindows/CVI. Computer Engineering and Designing, 2013, 31(1): 203-205.
[12] CHEN Ying-li, LIU Fan-ming, WANG Jian-min. Accessing to Excel based on activeX technology in LabWindows/CVI. Measurement and Control Technology, 2008, 27(6): 62-64.
[13] JIA Hong-jian, DONG Xiao-lei, FU Yong-ling, et al. Approaches of template reports generating based on LabWindows/CVI. Measurement and Control Technology, 2008, 27(8): 89-91.
[14] CHEN Peng, CAI Jin-yan, FAN Shi-you, et al. Designed of universal report interface library for fault diagnosis test system. Computer Measurement and Control, 2011, 19(11): 2607-2609.
基于LabWindows/CVI的特殊弹簧测试中Excel报表生成
靳璐1,2， 郑宾1,2， 陈昌鑫1,2
(1. 中北大学 电子测试技术国家重点实验室， 山西 太原 030051；2. 中北大学 仪器科学与动态测试教育部重点实验室， 山西 太原 030051)
摘要:针对LabWindows/CVI开发环境中测试数据报表生成局限性的问题， 根据实际工程经验提出了一种基于ActiveX技术访问Microsoft Excel 2003的方法。 该方法通过编程实现了在测控系统中自动生成数据报表并画出相应数据图表的功能， 增强了测试系统中生成报表的灵活性和通用性， 提高了实际工程效率。
关键词:LabWindows/CVI； ActiveX技术； Microsoft Excel 2003； 报表生成
引用格式：JIN Lu, ZHENG Bin, CHEN Chang-xin. Generation of Excel report in special spring testing system based on LabWindows/CVI. Journal of Measurement Science and Instrumentation, 2014, 5(3): 16-19. [doi: 10.3969/j.issn.1674-8042.2014.03.004]
[full text view]
