基于VBA的Excel测试用例对Word文档的自动转换  

Automatic Conversion of Word Documents Using Excel Test Cases Based on VBA

作　　者：原庆红 胡利方[2] YUAN Qinghong;HU Lifang(Taiyuan Aviation Instrument Co.,Ltd.,Taiyuan 030008,China;School of Materials Science and Engineering,Taiyuan University of Technology,Taiyuan 030024,China)

机构地区：[1]太原航空仪表有限公司,山西太原030008 [2]太原理工大学材料科学与工程学院,山西太原030024

出　　处：《科技创新与生产力》2024年第8期129-130,136,共3页Sci-tech Innovation and Productivity

摘　　要：本文指出软件测试人员通常在Word中编写测试用例后执行测试工作,由于测试用例数目过多造成Word文档冗长,编辑修改大规模的文档系统使其运行极其缓慢,常导致计算机死机,给测试工作带来不便。Excel作为Office应用程序中的一员,主要用来处理电子表格,同时可以被其他Office应用程序调用,因此本文提出在Excel中编写各测试用例,经修改完善后通过VBA程序转换成符合GJB5000A规范的配置项测试Word文档。Excel数据表编辑修改测试用例较直观便捷,能很大程度提高工作效率。This paper points out that software testers usually write test cases in Word and perform testing work.Due to the large number of test cases,Word documents become lengthy,and editing and modifying large-scale document systems make them run extremely slowly,often causing computer crashes and inconvenience to testing work.Excel,as a member of Office applications,is mainly used to process spreadsheets and can be called by other Office applications.Therefore,this paper proposes to write various test cases in Excel,modify and improve them,and convert them into configuration item test Word documents that comply with GJB5000A specifications through VBA programs.Editing and modifying test cases in Excel spreadsheets is intuitive and convenient,which can greatly improve work efficiency.

关 键 词：VBA Visual Basic 测试用例 

分 类 号：TP391.1[自动化与计算机技术—计算机应用技术]