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

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

扫码查看
本文指出软件测试人员通常在Word中编写测试用例后执行测试工作,由于测试用例数目过多造成Word文档冗长,编辑修改大规模的文档系统使其运行极其缓慢,常导致计算机死机,给测试工作带来不便.Excel作为Office应用程序中的一员,主要用来处理电子表格,同时可以被其他Office应用程序调用,因此本文提出在Excel中编写各测试用例,经修改完善后通过VBA程序转换成符合GJB5000A规范的配置项测试Word文档.Excel数据表编辑修改测试用例较直观便捷,能很大程度提高工作效率.
Automatic Conversion of Word Documents Using Excel Test Cases Based on VBA
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.

VBAVisual Basictest case

原庆红、胡利方

展开 >

太原航空仪表有限公司,山西 太原 030008

太原理工大学材料科学与工程学院,山西 太原 030024

VBA Visual Basic 测试用例

2024

科技创新与生产力
太原科技战略研究院

科技创新与生产力

影响因子:0.271
ISSN:1674-9146
年,卷(期):2024.45(8)