CN111258903A - Test case file conversion method, device and storage medium - Google Patents
Test case file conversion method, device and storage medium Download PDFInfo
- Publication number
- CN111258903A CN111258903A CN202010058322.7A CN202010058322A CN111258903A CN 111258903 A CN111258903 A CN 111258903A CN 202010058322 A CN202010058322 A CN 202010058322A CN 111258903 A CN111258903 A CN 111258903A
- Authority
- CN
- China
- Prior art keywords
- test case
- case file
- excel
- key element
- file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention provides a test case file conversion method, which comprises the steps of respectively determining the content of an Xmind test case file and the format of an Excel test case file template; acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated by analyzing the format of the Excel test case file template to be generated and analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test case to correspond to the key element name one by one; and sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file. The invention can directly convert the complete Xmind version test case into the Excel version test case, thereby saving the cost and improving the efficiency.
Description
Technical Field
The invention relates to the technical field of document data processing, in particular to a method, a device and a storage medium for converting an Xmind test case file into an Excel test case file.
Background
Excel is an important component of microsoft office suite software, can perform processing, statistical analysis and auxiliary decision-making operation of various data, and is widely applied to numerous fields of management, financial statistics, finance and the like. Excel can meet most requirements of compiling test cases, but if a tested service system is huge and each module has a tight service connection, the idea of compiling the cases by using Excel is not clear and is not convenient to evaluate. And the use of the thought directed graph in Xmind can well comb the test cases, divide the test cases and establish certain business relation among the test cases.
The Xmind is a very practical commercial thinking map software, applies the most advanced Eclipse RCP software architecture in the world, fully creates easy-to-use and efficient visual thinking software, emphasizes the expandability, cross-platform, stability and performance of the software, and aims to use the advanced software technology to help users to really improve the productivity. The test case writing by using Xmind is more flexible, clear in thought and easier to revise.
However, most of the systems (such as a soldier system and a meditation system) for managing the test cases in the industry at present do not support the import of the Xmind file and only support the import of the Excel file, so a tester writes a test case outline through the Xmind and manually writes the test cases of the Excel version again according to the outline. Therefore, popularization and use of Xmind in the aspect of test case writing are hindered, the advantages of Xmind in the aspect of test case writing cannot be fully exerted, the labor cost of testers is increased, and the working efficiency is also reduced.
Disclosure of Invention
In view of the above problems, an object of the present invention is to provide a method, an apparatus, and a storage medium for converting a test case file, which can convert a complete xmnd version test case into a test case of an Excel version, so that the advantages of xmnd in writing test cases are fully exerted, and the test case file can be converted into an Excel version which can be input into a test case management system, thereby providing convenience for test case writers.
According to one aspect of the invention, a test case file conversion method is provided, which comprises the following steps:
s110: respectively determining the content of the Xmind test case file and the format of an Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
s120: acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated by analyzing the format of the Excel test case file template to be generated and analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test case to correspond to the key element name one by one; the key element names are names used for describing test items in the Excel test case file template;
s130: and sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file.
Further, before S110, the method further includes: and respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated are defined in a command line format.
Further, the command line format is a linux command line format, and a first reference name and a second reference name are defined; the first reference name is used for marking the Xmind test case file to be converted, and the second reference name is used for marking the template used by the Excel test case file to be generated.
In S120, analyzing the Excel test case file template to be generated by using an extension package xlwt, obtaining a formatting specification of the Excel test case file template to be generated, and obtaining a cell position where the predefined key element name is located.
In S120, the process of analyzing the data of each test case in the xmnd test case file to be converted includes: sorting the key element names according to the alphabetic sequence of the column positions of the cells where the key element names are located to form a key element name group; analyzing and converting the content of the Xmind test case file to be converted into the content in the JSON data format; and sequentially converting the data of each test case in the contents of the JSON data format into a key element data group by adopting a self-defined JSON data processing method.
Further, the process of converting the customized JSON data processing method into the key element data group includes: and extracting the value of the content in the JSON data format as a result set, performing parent-child association on the result set, and sequentially extracting parent node values and child node values at each level as data which are in one-to-one correspondence with the key element names in the key element name group to form a key element data group.
In S130, the data in the key element data groups are sequentially written into the columns corresponding to the key element names in the Excel test case file template, and the data in each key element data group is written into the columns corresponding to the key element names in the same row, so as to generate a final Excel version test case file.
According to another aspect of the present invention, there is provided a test case file conversion system, including:
the file content and format determining unit is used for respectively determining the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
the file template analysis unit is used for analyzing the format of the Excel test case file template to be generated and acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated;
the file content analysis unit is used for respectively analyzing the data of each test case in the Xmind test case file to be converted so as to enable the data in the test cases to correspond to the key element names one by one;
and the test case writing unit is used for sequentially writing the analyzed data in each test case into the columns corresponding to the cell positions where the key element names in the same row in the analyzed Excel test case file template are located according to the corresponding key element names so as to generate the Excel test case file.
According to another aspect of the present invention, an electronic device is provided, which includes a memory and a processor, wherein the memory stores a computer program, and the computer program implements the steps of the test case file conversion method when being executed by the processor.
According to another aspect of the present invention, a computer-readable storage medium is provided, in which a test case file conversion program is stored, and when the test case file conversion program is executed by a processor, the steps of the test case file conversion method are implemented.
The invention has the following beneficial effects: by using the method for converting the Xmind test case file into the Excel test case file, the Xmind test case can be automatically converted into the Excel form without repeatedly compiling the Xmind test case schema and the complete Excel version test case file, so that the time cost is saved, and the efficiency is obviously improved. The tester can enjoy the function of converting the Xmind test case into the Excel test case without purchasing the Xmind pro version at high cost, and the converted Excel test case can be adapted to all test case management systems.
To the accomplishment of the foregoing and related ends, one or more aspects of the invention comprise the features hereinafter fully described and particularly pointed out in the claims. The following description and the annexed drawings set forth in detail certain illustrative aspects of the invention. These aspects are indicative, however, of but a few of the various ways in which the principles of the invention may be employed. Further, the present invention is intended to include all such aspects and their equivalents.
Drawings
Other objects and results of the present invention will become more apparent and more readily appreciated as the same becomes better understood by reference to the following description and appended claims, taken in conjunction with the accompanying drawings. In the drawings:
FIG. 1 is a flowchart of a test case file transformation method according to embodiment 1 of the present invention;
FIG. 2 is an Xmind test case file to be converted in embodiment 1 of the present invention;
FIG. 3 is a file template of an Excel test case to be generated in embodiment 1 of the present invention;
FIG. 4 is a converted Excel test case file in embodiment 1 of the present invention;
FIG. 5 is a schematic diagram of a logical structure of a test case file conversion system according to embodiment 2 of the present invention;
fig. 6 is a schematic logic structure diagram of an electronic device according to embodiment 3 of the present invention.
The same reference numbers in all figures indicate similar or corresponding features or functions.
Detailed Description
In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of one or more embodiments. It may be evident, however, that such embodiment(s) may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to facilitate describing one or more embodiments
Noun interpretation
Test case: the Test Case (Test Case) is a scientific organization summary of the behavior activity of the software Test, and aims to convert the behavior of the software Test into a manageable mode; meanwhile, the test case is also one of methods for specifically quantifying the test, and the test cases are different for different types of software. Usually, one test case file contains a plurality of test cases.
Extension packet xlwt: in Python language, an extension tool for Excel files is written.
JSON (JavaScript Object Notation) is a lightweight data exchange format. It stores and represents data in a text format that is completely independent of the programming language, based on a subset of ECMAScript (js specification set by the european computer association). The compact and clear hierarchy makes JSON an ideal data exchange language. The data structure is a key-value pair structure of { key1: value1, key2: value2,.. keyN: value N }. In an object-oriented language, key is an attribute of an object and value is a corresponding value.
Linux is a Unix-like operating system which is free to use and spread freely, and is a multi-user, multi-task, multi-thread and multi-CPU supporting operating system based on POSIX and UNIX.
Specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
Example 1
Fig. 1 is a flowchart of a test case file conversion method according to embodiment 1 of the present invention.
As shown in fig. 1, the test case file conversion method according to embodiment 1 of the present invention is applied to an electronic device, and is configured to convert an xmnd test case file into an Excel test case file, and includes the following steps:
s110: and respectively determining the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated.
In step S110, the PYTHON language is used to analyze the xmnd test case file to be converted to obtain the content thereof, and the Java language is used to analyze the Excel test case file template to be generated to obtain the format thereof.
S120: acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated by analyzing the format of the Excel test case file template to be generated and analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test case to correspond to the key element name one by one; the key element names are names used for describing test items in the Excel test case file template; the number of the key elements is determined according to the actual situation of the test case.
In step S120, the Excel test case file template to be generated is analyzed by using the extension packet xlwt to obtain the cell position where the predefined key element name in the Excel test case file template to be generated is located, and the data of each test case in the Xmind test case file to be converted is analyzed by using the analysis packet xmindarser to convert the data into the content in the JSON data format. And enabling the test case data in the content converted into the JSON data format to correspond to the key element names one by one.
S130: and sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file.
The writing mode is the mode of adopting an extension packet xlwt. And adopting an extension packet xlwt to write the analyzed data of each test case, namely each data in the key element data group, into the columns corresponding to the key element names in the Excel test case file template in sequence, and writing the data in each key element data group into the same row, and finally generating the converted Excel test case file.
Before S110, the method further includes: and respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated are defined in a command line format.
And respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, and acquiring the content of the Xmind test case file and the format of the Excel test case file template.
All Xmind test case files and all Excel test case file templates are stored in the memory. All Excel test case file templates comprise Excel test case file templates suitable for various test case management systems.
And determining an Excel test case file template to be generated according to the import file rule of the used test case management system and the Xmind test case file to be converted.
Reading an Xmind test case file to be converted and an Excel test case file template to be generated, wherein the specific process comprises the following steps: and defining the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated in a command line format. The command line format may use the linux command line format. Defining the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated by a linux command line format, specifically, transmitting the file name of the Xmind test case file to be converted by-x, transmitting the file name of the Excel test case file template to be generated by-e, and transmitting both-x and-e to the reference name of the program. The file name of the Xmind test case file is transmitted x and used for marking and calling the Xmind test case file to be converted, and the file name of the Excel test case file template is transmitted e and used for marking and calling the template used by the Excel test case file to be generated.
For example, in practical application, for example, an Xmind test case file to be converted is named as a "platform project test case, Xmind", and is to be converted into a test case of an Excel version according to an Excel test case file template named as a "platform project test case template, xls", and a call command should be "python rxind.
On the other hand, if the tester only adopts one Excel test case file template, the Excel test case file template to be generated is the specified Excel test case file template.
The file reading mode can be that an Xmind test case file to be converted and a default Excel test case file template are read, and the specific process comprises the following steps: setting the template file name of the Excel test case as a default file name of the Excel test case file, only defining the Xmind test case file reading mode to be converted in a command line format, and transmitting the Xmind test case file to be converted into the x file name of the Xmind test case file to be converted without repeatedly defining the Excel test case template file reading mode. For example, the call command should be "python rxmind.
The method of the present application may employ a PYTHON language environment.
In S120, the Excel test case file template format to be generated is analyzed, and the cell position where the predefined key element name is located in the Excel test case file template to be generated is obtained, which includes the specific processes: analyzing the Excel test case file template to be generated by adopting the extension packet xlwt, and acquiring a formatting specification of the Excel test case file template to be generated so as to acquire the position of a cell where the predefined key element name is located.
Fig. 3 is a file template of an Excel test case to be generated in embodiment 1 of the present invention.
As shown in fig. 3, the name of the Excel test case file template to be generated is a platform project test case template, xls, the name describing the test case test item in this template includes "test case path, test case name, test case description, test case step, test case expected result", so the key element name is predefined as: test case path, test case name, test case description, test case steps, and test case expected results.
After the platform project test case template is analyzed by xls, the position of the cell where the test case path is located is obtained as Sheet 1! $ A $1, the column position is A column; the cell location at which the test case name is located is Sheet 1! $ B $1, the column position is B column; the cell location where the test case description is located is Sheet 1! $ C $1, column position C column, cell position at test case step Sheet 1! E $1, the column position is E column; the cell location where the test case expected result is located is Sheet 1! And $ F $1, the column position is column F.
Analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test cases to correspond to the key element names one by one, wherein the specific process comprises the following steps: sorting the key element names according to the alphabetic sequence of the column positions of the cells to form a key element name group; and analyzing and converting the content of the Xmind test case file to be converted into the content in the JSON data format, and sequentially converting the data of each test case in the content in the JSON data format into a key element data group by adopting a self-defined JSON data processing method. The Xmind parsing packet Xmindparser can be adopted to convert the content of the Xmind test case file into the content in the JSON data format. The number of the key element data groups is the same as that of the test cases in the Xmind test case file, and each test case has a corresponding key element data group.
Converting the JSON data into a key element data group by adopting a customized JSON data processing method, wherein the process comprises the following steps: and extracting the value of each test case in the content of the JSON data format as a result set, performing parent-child association on each result set respectively, and sequentially extracting parent node values and child node values at each level as data which are in one-to-one correspondence with key element names in the key element name group to form key element data groups.
In an Excel test case file template named as ' platform project test case template ' xls ' shown in FIG. 3, key element names are sorted according to the alphabetical sequence of the column positions of the cells, and a formed key element name group is a { test case path; a test case name; describing a test case; testing cases; expected results of test cases }.
FIG. 2 is an Xmind test case file to be converted in embodiment 1 of the present invention.
The contents of the Xmind test case file to be converted, having a file name of "platform project test case. Xmind" as shown in FIG. 2, are converted into JSON data format with the result that { ' title ': platform project case ', ' topics ': [ { ' title ': query check ', ' topics ': { ' title ': order number ', ' topics ': [ { ' title ': text box: support fuzzy search ' }, { ' title ': is null: querying all approved redemption order libraries ' under the organization, { ' title ': fuzzy search: the inquiry fuzzy searches the approved filed order library ' under the organization, { ' title ': full word search: the query full word searches the approved filed redemption order library ' under the organization, { ' title ': special character: the query result is null' }. Therefore, the Xmind test case file content in the logic diagram form is converted into the JSON data format.
Then, the JSON data format content obtained by analyzing and converting the xmnd test case file content is further processed by using the customized JSON data processing method in the embodiment, so as to obtain the data of each test case required by writing the analyzed Excel test case file template in the next step. Extracting a value of a first test case in the content of a JSON data format into a result set, performing parent-child association on the result set, extracting a parent node (platform project test case) as data corresponding to a key element test case path, taking a first-level child node (inquiry check _ order number) as data corresponding to a key element test case name, taking a second-level child node (text box: supporting fuzzy search) as data corresponding to key element test case description, splitting the data corresponding to the key element test case description into data (text box) corresponding to a key element test case step and data (supporting fuzzy search) corresponding to a key element test case expected result according to a colon number, and forming a key element data group of the first test case, wherein the result is as follows: (test case path) platform project test cases; (test case name) inquiry check _ order number; (test case description) text box: supporting fuzzy search; (test case step) text box, (test case expected result) supports fuzzy search. Then, other test cases are converted into key element data sets corresponding to the test cases one by one.
Fig. 4 is a converted Excel test case file in embodiment 1 of the present invention.
In the embodiment, the test case with the file name "platform project test case. xmnd" shown in fig. 2 is converted into the test case of the Excel version according to the template with the file name "platform project test case template. xls" according to the method of the present invention, as shown in fig. 4.
The method for converting the Xmind test case file into the Excel test case file can automatically convert the Xmind test case into the Excel form without repeatedly compiling the Xmind test case outline and the complete Excel version test case file, saves time and cost and obviously improves efficiency. The tester can enjoy the function of converting the Xmind test case into the Excel test case without purchasing the Xmind pro version at high cost, and the converted Excel test case can be adapted to all test case management systems.
Example 2
Fig. 5 is a schematic diagram of a logical structure of the test case file conversion system according to embodiment 2 of the present invention.
As shown in fig. 5, a test case file conversion system is used for converting an xmnd test case file into an Excel test case file, and includes:
the file content and format determining unit is used for respectively determining the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
the file template analysis unit is used for analyzing the format of the Excel test case file template to be generated and acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated;
the file content analysis unit is used for respectively analyzing the data of each test case in the Xmind test case file to be converted so as to enable the data in the test cases to correspond to the key element names one by one;
and the test case writing unit is used for sequentially writing the analyzed data in each test case into the columns corresponding to the cell positions where the key element names in the same row in the analyzed Excel test case file template are located according to the corresponding key element names so as to generate the Excel test case file.
The system for converting the Xmind test case file into the Excel test case file can automatically convert the Xmind test case into the Excel form without repeatedly compiling an Xmind test case outline and a complete Excel version test case file, saves time and cost and obviously improves efficiency. The tester can enjoy the function of converting the Xmind test case into the Excel test case without purchasing the Xmind pro version at high cost, and the converted Excel test case can be adapted to all test case management systems.
Example 3
Fig. 6 is a schematic logic structure diagram of an electronic device according to embodiment 3 of the present invention.
As shown in fig. 6, an electronic device 1 includes a memory 3 and a processor 2, a computer program 4 is stored in the memory 3, and the computer program 4 implements the steps of the test case file conversion method in embodiment 1 when executed by the processor 2.
The computer program 4 includes a file reading program, a file parsing program, and a file writing program, and when the programs are executed by the processor 2, the following operations can be implemented:
the file reading program is executed by the processor, respectively reads an Xmind test case file to be converted and an Excel test case file template to be generated, and respectively determines the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
the file analysis program is executed by the processor, the Excel test case file template analysis program to be generated analyzes the format of the Excel test case file template to be generated, and the position of a cell where a key element name defined in advance in the Excel test case file template to be generated is located is obtained; analyzing the data of each test case in the Xmind test case file to be converted by an Xmind test case file analyzing program to make the data in the test cases correspond to the key element names one by one;
and when the file writing program is executed by the processor, sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file.
Example 4
A computer readable storage medium, in which a test case file conversion program is stored, and when the test case file conversion program is executed by a processor, the steps of the method for converting the test case file in embodiment 1 are implemented. The test case conversion-based program may include the file reading program, the file parsing program, and the file writing program.
The method, apparatus and storage medium for converting xmnd test case file into Excel test case file according to the present invention are described above by way of example with reference to fig. 1, fig. 2, fig. 3, fig. 4, fig. 5 and fig. 6. However, it should be understood by those skilled in the art that various modifications may be made to the method, apparatus and storage medium for converting xmnd test case file into Excel test case file provided in the present invention without departing from the scope of the present invention. Therefore, the scope of the present invention should be determined by the contents of the appended claims.
Claims (10)
1. A test case file conversion method is characterized by comprising the following steps:
s110: respectively determining the content of the Xmind test case file and the format of an Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
s120: acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated by analyzing the format of the Excel test case file template to be generated and analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test case to correspond to the key element name one by one; the key element names are names used for describing test items in the Excel test case file template;
s130: and sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file.
2. The test case file conversion method of claim 1, before S110, further comprising: and respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated are defined in a command line format.
3. The test case file conversion method of claim 2, wherein the command line format is a linux command line format, defining a first reference name and a second reference name; the first reference name is used for marking the Xmind test case file to be converted, and the second reference name is used for marking the template used by the Excel test case file to be generated.
4. The test case file conversion method according to claim 1, wherein in S120, the Excel test case file template to be generated is analyzed by using an extension package xlwt, a formatting specification of the Excel test case file template to be generated is obtained, and a cell position where the predefined key element name is located is obtained.
5. The method according to claim 1, wherein in S120, the process of parsing the data of each test case in the xmnd test case file to be converted includes:
sorting the key element names according to the alphabetic sequence of the column positions of the cells where the key element names are located to form a key element name group; analyzing and converting the content of the Xmind test case file to be converted into the content in the JSON data format; and sequentially converting the data of each test case in the contents of the JSON data format into a key element data group by adopting a self-defined JSON data processing method.
6. The test case file transformation method of claim 5, wherein the process of transforming into key element data groups using the customized JSON data processing method comprises:
and extracting the value of the content in the JSON data format as a result set, performing parent-child association on the result set, and sequentially extracting parent node values and child node values at each level as data which are in one-to-one correspondence with the key element names in the key element name group to form a key element data group.
7. The method for converting the test case file according to claim 6, wherein in S130, the data in the key element data group is sequentially written into the columns corresponding to the key element names in the Excel test case file template, and the data in each key element data group is written into the columns corresponding to the key element names in the same row, so as to generate the final Excel version test case file.
8. A test case file conversion system, comprising:
the file content and format determining unit is used for respectively determining the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;
the file template analysis unit is used for analyzing the format of the Excel test case file template to be generated and acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated;
the file content analysis unit is used for respectively analyzing the data of each test case in the Xmind test case file to be converted so as to enable the data in the test cases to correspond to the key element names one by one;
and the test case writing unit is used for sequentially writing the analyzed data in each test case into the columns corresponding to the cell positions where the key element names in the same row in the analyzed Excel test case file template are located according to the corresponding key element names so as to generate the Excel test case file.
9. An electronic device comprising a memory and a processor, wherein the memory stores a computer program, and the computer program when executed by the processor implements the steps of the test case file conversion method according to any one of claims 1 to 7.
10. A computer-readable storage medium, in which a test case file conversion program is stored, and when the test case file conversion program is executed by a processor, the steps of the test case file conversion method according to any one of claims 1 to 7 are implemented.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010058322.7A CN111258903A (en) | 2020-01-19 | 2020-01-19 | Test case file conversion method, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010058322.7A CN111258903A (en) | 2020-01-19 | 2020-01-19 | Test case file conversion method, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111258903A true CN111258903A (en) | 2020-06-09 |
Family
ID=70949369
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010058322.7A Pending CN111258903A (en) | 2020-01-19 | 2020-01-19 | Test case file conversion method, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111258903A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881053A (en) * | 2020-08-04 | 2020-11-03 | 北京四维智联科技有限公司 | Test case format conversion method and device and computer equipment |
| CN112346987A (en) * | 2020-11-25 | 2021-02-09 | 武汉光庭信息技术股份有限公司 | Test case generation and conversion method and system based on Xmind |
| CN113094288A (en) * | 2021-05-18 | 2021-07-09 | 绿漫科技有限公司 | Method for converting mind map into test case based on Xmind |
| CN113760698A (en) * | 2020-07-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Method and device for converting test case file data |
-
2020
- 2020-01-19 CN CN202010058322.7A patent/CN111258903A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113760698A (en) * | 2020-07-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Method and device for converting test case file data |
| CN111881053A (en) * | 2020-08-04 | 2020-11-03 | 北京四维智联科技有限公司 | Test case format conversion method and device and computer equipment |
| CN112346987A (en) * | 2020-11-25 | 2021-02-09 | 武汉光庭信息技术股份有限公司 | Test case generation and conversion method and system based on Xmind |
| CN113094288A (en) * | 2021-05-18 | 2021-07-09 | 绿漫科技有限公司 | Method for converting mind map into test case based on Xmind |
| CN113094288B (en) * | 2021-05-18 | 2022-06-21 | 绿漫科技有限公司 | Method for converting mind map into test case based on Xmind |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111258903A (en) | Test case file conversion method, device and storage medium | |
| US8959122B2 (en) | Data processing device | |
| CN111367976B (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN110347598B (en) | Test script generation method and device, server and storage medium | |
| CN111176996A (en) | Test case generation method and device, computer equipment and storage medium | |
| MacNair et al. | Elements of practical performance modeling | |
| JPH0612452A (en) | Group information access system | |
| US9141344B2 (en) | Hover help support for application source code | |
| CN117112806B (en) | Knowledge graph-based information structuring method and device | |
| Behrang et al. | Automated test migration for mobile apps | |
| CN111368167A (en) | Chinese literature data automatic acquisition method based on web crawler technology | |
| Hopkins et al. | ReadMe: Software for automated content analysis | |
| Matter | Big data analytics: a guide to data science practitioners making the transition to big data | |
| JP6870454B2 (en) | Analytical equipment, analytical programs and analytical methods | |
| CN111125264B (en) | Extra-large set analysis method and device based on extended OLAP model | |
| CN115238037A (en) | Function point generation method and device based on agile user story | |
| CN112214494A (en) | Retrieval method and device | |
| CN110807017A (en) | AWR report analysis method based on Beautiful Soup analysis technology | |
| Adamenko et al. | Development of a System for Static Analysis of C++ Language Code | |
| US11681862B1 (en) | System and method for identifying location of content within an electronic document | |
| Kimball et al. | A Method and Tool for Automated Induction of Relations from Quantitative Performance Logs | |
| CN109359143B (en) | Report generation method and device | |
| McGregor et al. | Stabdump—A dump interpreter program to assist debugging | |
| Hollaar | The Utah text retrieval project: A status report | |
| Tian et al. | Research and implementation of a desktop full-text search system based on Hyper Estraier |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |