CN104156342A - Method and device for converting Excel format testing case into XML (extensive markup language) format - Google Patents
Method and device for converting Excel format testing case into XML (extensive markup language) format Download PDFInfo
- Publication number
- CN104156342A CN104156342A CN201410375533.8A CN201410375533A CN104156342A CN 104156342 A CN104156342 A CN 104156342A CN 201410375533 A CN201410375533 A CN 201410375533A CN 104156342 A CN104156342 A CN 104156342A
- Authority
- CN
- China
- Prior art keywords
- test case
- xml
- information data
- excel
- excel form
- 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
Landscapes
- Debugging And Monitoring (AREA)
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
The present invention relates to a kind of method and device that Excel form test case is transferred to XML form.
Background technology
At present, the newly-built use-case of use test case management instrument, the operation of maintenance use case is more loaded down with trivial details, employee is input test use-case one by one, when use-case will be revised, be also to revise one by one, work efficiency is low, some test case management instrument only supports to import the use-case of XML form, and that the test case of XML form is write in artificial going is very loaded down with trivial details, very easily go wrong, for example: the test case management instrument Testlink increasing income at present, in industry use procedure, all there is following shortcoming: only support the test case of XML form to import, and be manually difficult to design the test case of XML form, if without use-case import feature, direct newly-built use-case in Testlink instrument, efficiency is very low, use the manual use-case of building in Testlink the inside, the form after derivation is limited, is not easy to the evaluation operation of test case, the case maintenance of Testlink the inside is also cumbersome, if can pass through use-case import feature, convenient.
Summary of the invention
One of the technical problem to be solved in the present invention, is to provide a kind of method that Excel form test case is transferred to XML form, has improved efficiency, has reduced human cost.
One of technical matters that the present invention solves is achieved in that a kind of method that Excel form test case is transferred to XML form, comprises the steps:
Step 10, set up the test case template of Excel form, and test case information data is inserted in described test case template;
Step 20, analytical test case management instrument import the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
The scope that needs to derive test case information data in step 30, selected Excel form test case template, generates XML file by the information data within the scope of this according to XML call format.
Further, between described step 10 and step 20, also comprise step 11, the XML file storing path of generation is set, in described step 30, generate after XML file, according to storing path, preserve.
Further, described step 30 is further specially:
According to the scope that need to derive test case information data selected in Excel form test case template, the XML call format that information data within the scope of this is imported according to analytical test case management instrument, write in node corresponding in XML file, generate XML file.
Further, described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information.
Further, described Excel form is " .xls " form or " .et " form.
Two of the technical problem to be solved in the present invention, is to provide a kind of device that Excel form test case is transferred to XML form, has improved efficiency, has reduced human cost.
Two of the technical matters that the present invention solves is achieved in that a kind of device that Excel form test case is transferred to XML form, comprises as lower module:
Information arranges module, sets up the test case template of Excel form, and test case information data is inserted in described test case template;
Analyze respective modules, analytical test case management instrument imports the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
Read and generate XML file module, in selected Excel form test case template, need to derive the scope of test case information data, the information data within the scope of this is generated to XML file according to XML call format.
Further, described information arranges module and analyzes between respective modules and is provided with:
Storing path module, for the XML file storing path of generation is set, generates after XML file module generation XML file described reading, and according to storing path, preserves.
Further, described in, reading generation XML file module is further specially:
According to the scope that need to derive test case information data selected in Excel form test case template, the XML call format that information data within the scope of this is imported according to analytical test case management instrument, write in node corresponding in XML file, generate XML file.
Further, described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information.
Further, described Excel form is " .xls " form or " .et " form.
Tool of the present invention has the following advantages: a kind of method and device that Excel form test case is transferred to XML form of the present invention, can easily the test case of Excel form be transferred to Xml form, improve the efficiency that our Test Sample Designs, test case import, facilitated our follow-up case maintenance.
Accompanying drawing explanation
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the inventive method flowchart.
Fig. 2 is the structural representation block diagram of apparatus of the present invention.
Embodiment
As shown in Figure 1, the present invention transfers Excel form test case to the method for XML form, comprises the steps:
Step 10, set up the test case template of Excel form, and test case information data is inserted in described test case template, described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information, and described Excel form is " .xls " form or " .et " form;
Step 11, the Xml file storing path of generation is set.
Step 20, analytical test case management instrument import the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
Corresponding relation is for example: " test subsystems title " row in Excel test case template correspond to " testsuite " node of Xml file, " submodule title " row correspond to " testcase " node of Xml file, " test case title " row correspond to " name " node of Xml file, " operation steps " row correspond to " actions " node of Xml file, " expected result " row correspond to " expectedresults " node of Xml file, the respective operations of other row is similar, exactly the row of Excel form the inside are carried out corresponding with the interdependent node of Xml.
In step 30, the selected Excel form test case template of basis, need to derive the scope of test case information data, from Excel form, take out needed test case information data, and the XML call format importing according to the use-case of case management instrument generates XML file, afterwards taken out test case data is written to node the inside corresponding in described XML file, the storing path generating according to step 11 is preserved.
Selected use-case scope is given an example: such as having set up 20 test cases in test case template, can select wherein the 5th to 15 test cases to derive operation.
As shown in Figure 2, the present invention transfers Excel form test case in the device of XML form, comprises as lower module:
Information arranges module, set up the test case template of Excel form, and test case information data is inserted in described test case template, described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information, and described Excel form is " .xls " form or " .et " form;
Storing path module, arranges the XML file storing path of generation;
Analyze respective modules, analytical test case management instrument imports the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
Read and generate XML file module, according to the scope that need to derive test case information data selected in Excel form test case template, the XML call format that information data within the scope of this is imported according to analytical test case management instrument, write in node corresponding in XML file, generate XML file, the storing path generating according to storing path module is preserved XML file.
Tool of the present invention has the following advantages: a kind of method and device that Excel form test case is transferred to XML form of the present invention, can easily the test case of Excel form be transferred to Xml form, improve the efficiency that our Test Sample Designs, test case import; When test case content is wanted batch modification, can in test case template, carry out batch modification, then by Batch conversion mode, transfer unified importing after Xml form to, greatly improved maintenance efficiency, facilitated our follow-up case maintenance.
Although more than described the specific embodiment of the present invention; but being familiar with those skilled in the art is to be understood that; our described specific embodiment is illustrative; rather than for the restriction to scope of the present invention; those of ordinary skill in the art are in equivalent modification and the variation done according to spirit of the present invention, all should be encompassed in the scope that claim of the present invention protects.
Claims (10)
1. Excel form test case is transferred to a method for XML form, it is characterized in that: comprise the steps:
Step 10, set up the test case template of Excel form, and test case information data is inserted in described test case template;
Step 20, analytical test case management instrument import the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
The scope that needs to derive test case information data in step 30, selected Excel form test case template, generates XML file by the information data within the scope of this according to XML call format.
2. a kind of method that Excel form test case is transferred to XML form according to claim 1, it is characterized in that: between described step 10 and step 20, also comprise step 11, the XML file storing path of generation is set, in described step 30, generate after XML file, according to storing path, preserve.
3. a kind of method that Excel form test case is transferred to XML form according to claim 1, is characterized in that: described step 30 is further specially:
According to the scope that need to derive test case information data selected in Excel form test case template, the XML call format that information data within the scope of this is imported according to analytical test case management instrument, write in node corresponding in XML file, generate XML file.
4. according to a kind of method that Excel form test case is transferred to XML form described in claim 1 or 3, it is characterized in that: described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information.
5. according to a kind of method that Excel form test case is transferred to XML form described in claim 1 or 3, it is characterized in that: described Excel form is " .xls " form or " .et " form.
6. Excel form test case is transferred to a device for XML form, it is characterized in that: comprise as lower module:
Information arranges module, sets up the test case template of Excel form, and test case information data is inserted in described test case template;
Analyze respective modules, analytical test case management instrument imports the XML call format of use-case, and the test case information data that writes Excel form is carried out corresponding one by one with each node of XML the inside;
Read and generate XML file module, in selected Excel form test case template, need to derive the scope of test case information data, the information data within the scope of this is generated to XML file according to XML call format.
7. a kind of device that Excel form test case is transferred to XML form according to claim 6, is characterized in that: described information arranges module and analyzes between respective modules and is provided with:
Storing path module, for the XML file storing path of generation is set, generates after XML file module generation XML file described reading, and according to storing path, preserves.
8. a kind of device that Excel form test case is transferred to XML form according to claim 6, is characterized in that: described in read and generate XML file module and be further specially:
According to the scope that need to derive test case information data selected in Excel form test case template, the XML call format that information data within the scope of this is imported according to analytical test case management instrument, write in node corresponding in XML file, generate XML file.
9. according to a kind of device that Excel form test case is transferred to XML form described in claim 6 or 8, it is characterized in that: described test case information data comprises: test subsystems title, submodule title, test case title, test-types, priority, summary, prerequisite, operation steps, expected result information.
10. according to a kind of device that Excel form test case is transferred to XML form described in claim 6 or 8, it is characterized in that: described Excel form is " .xls " form or " .et " form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410375533.8A CN104156342A (en) | 2014-08-01 | 2014-08-01 | Method and device for converting Excel format testing case into XML (extensive markup language) format |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410375533.8A CN104156342A (en) | 2014-08-01 | 2014-08-01 | Method and device for converting Excel format testing case into XML (extensive markup language) format |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104156342A true CN104156342A (en) | 2014-11-19 |
Family
ID=51881847
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410375533.8A Pending CN104156342A (en) | 2014-08-01 | 2014-08-01 | Method and device for converting Excel format testing case into XML (extensive markup language) format |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104156342A (en) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391796A (en) * | 2014-12-05 | 2015-03-04 | 上海斐讯数据通信技术有限公司 | Method for parsing test cases |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN106033389A (en) * | 2015-03-11 | 2016-10-19 | 腾讯科技（深圳）有限公司 | A test use case display method and device |
| CN108009264A (en) * | 2017-12-14 | 2018-05-08 | 北京航天测控技术有限公司 | A kind of comparative approach of versions of data for Excel format files |
| CN108628748A (en) * | 2018-05-09 | 2018-10-09 | 平安普惠企业管理有限公司 | Automatic test management method and automatic test manage system |
| WO2019056720A1 (en) * | 2017-09-21 | 2019-03-28 | 平安科技（深圳）有限公司 | Automated test case management method and apparatus, device, and storage medium |
| CN109543157A (en) * | 2018-10-23 | 2019-03-29 | 深圳市海勤科技有限公司 | Android scheme OSD language transfer method |
| CN109614519A (en) * | 2018-12-07 | 2019-04-12 | 万兴科技股份有限公司 | Data lead-in method and data importing device |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN109885476A (en) * | 2018-12-14 | 2019-06-14 | 平安万家医疗投资管理有限责任公司 | Automated testing method and device, terminal and computer readable storage medium |
| CN110597708A (en) * | 2019-08-02 | 2019-12-20 | 北京奇艺世纪科技有限公司 | Test case file conversion method and device, electronic equipment and storage medium |
| CN110941546A (en) * | 2019-10-12 | 2020-03-31 | 平安健康保险股份有限公司 | Automatic test method, device, equipment and storage medium for WEB page case |
| CN111191419A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Excel-to-xml method and system applicable to testlink |
| CN111767223A (en) * | 2020-06-29 | 2020-10-13 | 北京奇艺世纪科技有限公司 | File processing method and device, electronic equipment and storage medium |
| CN112560415A (en) * | 2020-12-18 | 2021-03-26 | 深圳市元征科技股份有限公司 | Data processing method, device, equipment and medium |
| CN113095044A (en) * | 2021-04-13 | 2021-07-09 | 中国工商银行股份有限公司 | File conversion method, device and equipment |
| CN113110993A (en) * | 2021-04-12 | 2021-07-13 | 深圳市吉祥腾达科技有限公司 | Method for integrating and butting testlink system by automatic test platform |
| CN113778886A (en) * | 2021-09-15 | 2021-12-10 | 北京天融信网络安全技术有限公司 | Test case processing method and device |
-
2014
- 2014-08-01 CN CN201410375533.8A patent/CN104156342A/en active Pending
Cited By (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104391796A (en) * | 2014-12-05 | 2015-03-04 | 上海斐讯数据通信技术有限公司 | Method for parsing test cases |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN104484419B (en) * | 2014-12-17 | 2018-02-13 | 上海斐讯数据通信技术有限公司 | A kind of converting system and method for test case document |
| CN106033389B (en) * | 2015-03-11 | 2019-02-12 | 腾讯科技（深圳）有限公司 | Test case methods of exhibiting and device |
| CN106033389A (en) * | 2015-03-11 | 2016-10-19 | 腾讯科技（深圳）有限公司 | A test use case display method and device |
| WO2019056720A1 (en) * | 2017-09-21 | 2019-03-28 | 平安科技（深圳）有限公司 | Automated test case management method and apparatus, device, and storage medium |
| CN108009264A (en) * | 2017-12-14 | 2018-05-08 | 北京航天测控技术有限公司 | A kind of comparative approach of versions of data for Excel format files |
| CN108009264B (en) * | 2017-12-14 | 2020-08-25 | 北京航天测控技术有限公司 | Comparison method for data versions of Excel format documents |
| CN108628748A (en) * | 2018-05-09 | 2018-10-09 | 平安普惠企业管理有限公司 | Automatic test management method and automatic test manage system |
| CN108628748B (en) * | 2018-05-09 | 2023-11-03 | 新疆北斗同创信息科技有限公司 | Automatic test management method and automatic test management system |
| CN109543157A (en) * | 2018-10-23 | 2019-03-29 | 深圳市海勤科技有限公司 | Android scheme OSD language transfer method |
| CN109543157B (en) * | 2018-10-23 | 2021-02-05 | 深圳市海勤科技有限公司 | OSD language conversion method of android scheme |
| CN109614519A (en) * | 2018-12-07 | 2019-04-12 | 万兴科技股份有限公司 | Data lead-in method and data importing device |
| CN109614519B (en) * | 2018-12-07 | 2021-06-15 | 万兴科技股份有限公司 | Data import method and data import device |
| CN109885476A (en) * | 2018-12-14 | 2019-06-14 | 平安万家医疗投资管理有限责任公司 | Automated testing method and device, terminal and computer readable storage medium |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN110597708A (en) * | 2019-08-02 | 2019-12-20 | 北京奇艺世纪科技有限公司 | Test case file conversion method and device, electronic equipment and storage medium |
| CN110941546A (en) * | 2019-10-12 | 2020-03-31 | 平安健康保险股份有限公司 | Automatic test method, device, equipment and storage medium for WEB page case |
| CN111191419A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Excel-to-xml method and system applicable to testlink |
| CN111767223A (en) * | 2020-06-29 | 2020-10-13 | 北京奇艺世纪科技有限公司 | File processing method and device, electronic equipment and storage medium |
| CN111767223B (en) * | 2020-06-29 | 2024-02-23 | 北京奇艺世纪科技有限公司 | File processing method and device, electronic equipment and storage medium |
| CN112560415A (en) * | 2020-12-18 | 2021-03-26 | 深圳市元征科技股份有限公司 | Data processing method, device, equipment and medium |
| CN113110993A (en) * | 2021-04-12 | 2021-07-13 | 深圳市吉祥腾达科技有限公司 | Method for integrating and butting testlink system by automatic test platform |
| CN113095044A (en) * | 2021-04-13 | 2021-07-09 | 中国工商银行股份有限公司 | File conversion method, device and equipment |
| CN113778886A (en) * | 2021-09-15 | 2021-12-10 | 北京天融信网络安全技术有限公司 | Test case processing method and device |
| CN113778886B (en) * | 2021-09-15 | 2023-11-10 | 北京天融信网络安全技术有限公司 | Processing method and device for test cases |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104156342A (en) | Method and device for converting Excel format testing case into XML (extensive markup language) format | |
| CN104391826A (en) | Data format conversion method and data format converter | |
| CN104298496B (en) | data analysis type software development framework system | |
| CN110244936B (en) | Method and device for supporting VISIO flow chart to automatically import DCS algorithm configuration software | |
| CN108509339A (en) | Method for generating test case, device based on browser and mind map and equipment | |
| CN105335412A (en) | Method and device for data conversion and data migration | |
| CN104216961B (en) | A kind of data processing method and device | |
| CN103838672A (en) | Automated testing method and device for all-purpose financial statements | |
| CN101339534A (en) | Software test apparatus and test method | |
| CN105045775A (en) | Method and apparatus for generating Excel document in designated format | |
| CN110941427B (en) | Code generation method and code generator | |
| CN109740122A (en) | The conversion method and device of mind map use-case file | |
| CN104298595A (en) | Automatic testing method and testing system | |
| CN104731588B (en) | Page layout document generating method and page layout file creating apparatus | |
| CN104657274B (en) | software interface test method and device | |
| CN103544107A (en) | Method and device for generating test case document | |
| CN107657150A (en) | One kind visualization analysis of biological information instrument generation method and device | |
| CN102955740A (en) | Driving function and stub function generating method based on Perl | |
| CN104008042B (en) | A kind of UI automated testing methods, system and equipment | |
| CN109670129A (en) | A kind of method and device for switching to html web page to be adapted to MIP format | |
| CN106843872A (en) | Assignment conversion method | |
| CN103440197B (en) | A kind of method automatically generating difference test report based on contrast test | |
| CN106777404A (en) | Converting system and conversion method from LaTeX form to XML format | |
| US20150339106A1 (en) | Tabular format transaction editor | |
| CN105718434A (en) | Natural language formula editing method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141119 |