Method and device for converting Excel format testing case into XML (extensive markup language) format

Abstract

The invention provides a method for converting an Excel format testing case into an XML (extensive markup language) format. The method comprises the following steps of establishing a testing case template of an Excel format; filling information data of a testing case in the testing case template; analyzing XML format requirements on importation of the testing case by using a testing case management tool; corresponding contents of an Excel form to various nodes in XML one by one; selecting a range in which the information data of the testing case are required to be exported in the testing case template of the Excel format; and generating an XML file by using the information data in the range according to the requirements on the XML format. The invention also provides a device for converting the Excel format testing case into the XML format. The efficiency is improved; and the labor cost is reduced.

Description

technical field [0001] The invention relates to a method and a device for converting an Excel format test case into an XML format. Background technique [0002] At present, the operation of creating and maintaining test cases using test case management tools is relatively cumbersome. Employees can only input test cases one by one. When modifying use cases, they also modify them one by one. The work efficiency is low. Some test case management tools only support importing. Use cases in XML format, and artificially writing test cases in XML format is very cumbersome and prone to problems. For example, the current open source test case management tool Testlink has the following shortcomings in the process of use in the industry: it only supports test cases in XML format Import, and it is difficult to manually design test cases in XML format; if you do not use the use case import function, directly create a new test case in the Testlink tool, the efficiency is very low; use the ...

AI Technical Summary

Problems solved by technology

[0002] At present, the operation of creating and maintaining test cases using test case management tools is relatively cumbersome. Employees can only input test cases one by one. When modifying use cases, they also modify them one by one. The work efficiency is low. Some test case management tools only support importing. Use cases in XML format, and artificially writing test cases in XML format is very cumbersome and prone to problems. For example, the current open source test case management tool Testlink has the following shortcomings in the process of use in the industry: it only supports test cases in XML format Import, and it is difficult to manually design test cases in XML format; if you do not use the use case import function, directly create a new test case in the Testlink tool, the efficiency is very low; use the manually created test cases in Testlink, the exported format is limited, which is not convenient for test cases The review operation; the use case maintenance in Testlink is also more troublesome, it will be more convenient if the function can be imported through the use case

Images