摘要
Excel等办公软件在工程中有着极其广泛的应用,但缺点是很难对其进行直接数据调用与数据存储。介绍了在LabWindows/CVI环境下,基于ActiveX技术访问Excel的方法。创新性地综合了几种实现方式并阐述了访问Excel具体函数的使用,实现了对Excel的访问,克服了LabWindows/CVI自身在表格开发中的不足。通过编程验证竖琴弹簧的扭矩、转角、刚度等参数是否符合某项目所要求的性能指标等工程实例,说明了本方法极大地减轻了实际工程中的任务量,提高了工作效率,具有重要的工程实用价值。
Office software such as Excel has a very wide range of applications in engineering, but the disadvantage is that it is difficult to call and store data directly. The method of accessing Excel based on ActiveX technology in LabWindows/CVI environment is introduced. Several implementation methods are innovatively synthesized, the usage of specific functions of access Excel is expounded, the access to Excel is implemented, and the shortages of LabWindows/CVI itself in table development are overcome. By verifying that the parameters such as torque, rotation angle and stiffness of the harp spring are in line with the required performance indexes of the project, it shows that this method greatly reduces the amount of tasks in practical engineering, improves the work efficiency, and has important practical value in engineering.
作者
苏少雄
郑宾
SU Shao-xiong;ZHENG Bin(Data Science and Technology, North University of China, Taiyuan 030051, China;State Key Laboratory of Electronic Testing, Taiyuan 030051, China)
出处
《测控技术》
CSCD
2018年第5期128-131,共4页
Measurement & Control Technology
基金
国防基础科研计划资助项目(A1020120001)
