CN107679027A - Excel test case forms are converted to the method and device of Word test case forms - Google Patents
Excel test case forms are converted to the method and device of Word test case forms Download PDFInfo
- Publication number
- CN107679027A CN107679027A CN201710935796.3A CN201710935796A CN107679027A CN 107679027 A CN107679027 A CN 107679027A CN 201710935796 A CN201710935796 A CN 201710935796A CN 107679027 A CN107679027 A CN 107679027A
- Authority
- CN
- China
- Prior art keywords
- excel
- case
- thread
- test cases
- converted
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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/3676—Test management for coverage analysis
-
- 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
-
- 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/3688—Test management for test execution, e.g. scheduling of test suites
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a kind of method that Excel test cases form is converted to Word test case forms, wherein, including：Self-defined Excel test cases form writes template and MDB file configuration information tables；Obtain Excel test case forms；Read Excel test cases form and read MDB file configuration information tables simultaneously；Count the use-case quantity in Excel test case forms；A thread will be created per N number of use-case, and the thread is generated into intermediate document, obtains M intermediate document；M intermediate document is merged, obtains the Word test case forms that Excel test case forms are completely converted into.The invention also discloses the device that a kind of Excel test cases form is converted to Word test case forms.Excel test cases form provided by the invention is converted to the method migration efficiency high of Word test case forms.
Description
Technical field
The present invention relates to data for electronic documents processing technology field, more particularly to a kind of Excel test cases form to change
Method and a kind of Excel test cases form for Word test case forms are converted to the device of Word test case forms.
Background technology
In the prior art, the Digital electronic control system of high reliability demand is tested, to meet coverage rate
Tested it is required that hundreds of use-case need to be designed.Consider from the efficiency of test, intuitive, operability, typically using micro-
Soft Excel instruments carry out the establishment and execution of test case, and the mode for finally Excel tables being converted to again Word forms is carried out
Filing.Conversion time and effort consuming is carried out by the way of stickup is manually replicated, and human error easily occurs；It is grand using Microsoft
Code carries out form conversion, and it is stuck to easily cause Word, and not can configure.
Therefore, how to realize that Excel test case forms quickly are converted into Word test cases form turns into this
Art personnel technical problem urgently to be resolved hurrily.
The content of the invention
It is contemplated that at least solves one of technical problem present in prior art, there is provided a kind of Excel test cases
Form is converted to the method for Word test case forms and a kind of Excel test cases form is converted to Word test case forms
Device, to solve the problems of the prior art.
As the first aspect of the invention, there is provided a kind of Excel test cases form is converted to Word test case tables
The method of lattice, wherein, methods described includes：
Self-defined Excel test cases form writes template and MDB file configuration information tables, wherein Excel tests are used
Example form, which writes template, includes Column Properties information, described in the line number and row number correspondence in the MDB file configuration informations table
Excel test case forms write the row number in template；
Obtain and the Excel test cases form is write into template write the Excel test case forms that are obtained after use-case；
The Excel test cases form is read, and is stored in DataTable, while reads the MDB file configuration informations table
Into chained list LabelList, each element in the chained list LabelList is stored in the MDB file configuration informations table
Line number, the row number in row number and the MDB file configuration informations in the corresponding Excel test cases form；
Count the use-case quantity in the Excel test cases form；
A thread for being converted to Word test case forms will be created per N number of use-case, and the thread is generated into intermediate document, is obtained
M intermediate document is obtained, wherein the quantity of the thread and the quantity of the intermediate document correspond, 50≤N≤150, M≤
30, and quantity L≤4 of the thread run simultaneously；
M intermediate document is merged, obtains the Word test case tables that the Excel test cases form is completely converted into
Lattice.
Preferably, the self-defined Excel test cases form is write template and MDB file configuration information tables and included：
The mark for terminating null as single use-case in template is write in the Excel test cases form；
Write the Column Properties information that the Excel test cases form writes template；
Line number in the MDB file configuration informations table and row number are corresponded into the Excel test cases form to write in template
Row number.
Preferably, the use-case quantity in the statistics Excel test cases form includes：
The number of non-mentioned null cell in " use-case mark " row of the Excel test cases form is set as the total of test case
Number；
Count the number of the use-case successively from the top down.
Preferably, it is described that a thread for being converted to Word test case forms will be created per N number of use-case, and by the thread
Intermediate document is generated, obtaining M intermediate document includes：
According to the number of the use-case of statistics, judge whether the number of the use-case is less than N；
If the number of the use-case is less than N, all use-cases are created into a thread for being converted to Word test case forms, and
The thread is generated into an intermediate document, obtains an intermediate document；
If the number of the use-case is more than N, judge the use-case number whether the integral multiple for being N；
If the number of the use-case is N integral multiple, Word test case forms are converted to by creating one per N number of use-case
Thread, and each thread for being converted to Word test case forms is generated into an intermediate document, obtain M intermediate document；
If the number of the use-case is not N integral multiple, one will be created per N number of use-case and be converted to Word test case forms
Thread, by remaining use-case create a thread for being converted to Word test case forms, and by it is each be converted to Word survey
The thread of example form on probation generates an intermediate document, obtains M intermediate document.
Preferably, each thread includes Excel test cases form initial row corresponding to each use-case, Excel tests
Use-case form end line and thread id information.
Preferably, the title of the M intermediate document generates the order of the intermediate document according to each thread
Name.
Preferably, described merge M intermediate document is beaten successively including the establishment order according to each thread
The intermediate document is opened to merge.
Preferably, methods described is additionally included in the acquisition and the Excel test cases form is write into template writes use
Carried out before the Excel test case table steps obtained after example：
Self-defined Word test cases form template.
As the second aspect of the invention, there is provided a kind of Excel test cases form is converted to Word test case tables
The device of lattice, wherein, described device includes：
Custom block, the custom block writes template for self-defined Excel test cases form and MDB files are matched somebody with somebody
Information table is put, wherein the Excel test cases form, which writes template, includes Column Properties information, the MDB file configurations letter
Line number and row number in breath table correspond to the Excel test cases form and write row number in template；
Acquisition module, the acquisition module, which is used to obtain to write the Excel test cases form after template writes use-case, to be obtained
The Excel test case forms arrived；
Read module, the read module is used to read the Excel test cases form, and is stored in DataTable, simultaneously
The MDB file configuration informations table is read into chained list LabelList, each element in the chained list LabelList is deposited
Store up line number in the MDB file configuration informations table, the corresponding Excel in row number and the MDB file configuration informations
Row number in test case form；
Statistical module, the statistical module are used to count the use-case quantity in the Excel test cases form；
Creation module, the creation module are used to that a thread for being converted to Word test case forms will to be created per N number of use-case,
And the thread is generated into intermediate document, M intermediate document is obtained, wherein the quantity of the thread and the quantity of the intermediate document
Correspond, 50≤N≤150, M≤30, and quantity L≤4 of the thread run simultaneously；
Modular converter, the modular converter are used to merge M intermediate document, obtain the Excel test cases form
The Word test case forms being completely converted into.
Preferably, the custom block is additionally operable to self-defined Word test cases form template.
The method that Excel test cases form provided by the invention is converted to Word test case forms, by self-defined
Excel test case forms write template, are write in Excel test case forms and use-case is write in template, then pass through statistics
The quantity of use-case, and use-case is created to the thread for being converted to Word test case forms, thread is generated into intermediate document, it is final logical
Cross and merge the Word test case forms that the intermediate document acquisition Excel test cases form is completely converted into.The present invention carries
The method that the Excel test case forms of confession are converted to Word test case forms, by using the mode of thread process, parallel
Carry out the conversion of use-case form, efficiently improve the switching rate that Excel test case forms are converted to Word test case forms,
And it is easy to operate, securely and reliably.
Brief description of the drawings
Accompanying drawing is for providing a further understanding of the present invention, and a part for constitution instruction, with following tool
Body embodiment is used to explain the present invention together, but is not construed as limiting the invention.In the accompanying drawings：
Fig. 1 is the flow chart for the method that Excel test cases form provided by the invention is converted to Word test case forms.
Fig. 2 is that Excel test cases form provided by the invention is converted to step in the methods of Word test case forms
S110 embodiment.
Fig. 3 is that Excel test cases form provided by the invention is converted to step in the methods of Word test case forms
S140 embodiment.
Fig. 4 is that Excel test cases form provided by the invention writes template.
Fig. 5 is Word test cases form template provided by the invention.
Fig. 6 is the MDB file configuration information tables provided by the invention that need to be configured.
The structure that Fig. 7 provides the device that Excel test case forms are converted to Word test case forms for the present invention is shown
It is intended to.
Embodiment
The embodiment of the present invention is described in detail below in conjunction with accompanying drawing.It should be appreciated that this place is retouched
The embodiment stated is merely to illustrate and explain the present invention, and is not intended to limit the invention.
As the first aspect of the invention, there is provided a kind of Excel test cases form is converted to Word test case tables
The method of lattice, wherein, as shown in figure 1, methods described includes：
S110, self-defined Excel test cases form write template and MDB file configuration information tables, wherein the Excel is surveyed
Example form on probation, which writes template, includes Column Properties information, and the line number and row number in the MDB file configuration informations table correspond to institute
State Excel test case forms and write row number in template；
S120, obtain and the Excel test cases form is write into template write the Excel test case tables that are obtained after use-case
Lattice；
S130, the Excel test cases form is read, and be stored in DataTable, while read the MDB file configurations
For information table into chained list LabelList, each element in the chained list LabelList stores the MDB file configurations letter
Row in line number, row number and the MDB file configuration informations in breath table in the corresponding Excel test cases form
Number；
Use-case quantity in S140, the statistics Excel test cases form；
S150, a thread for being converted to Word test case forms will be created per N number of use-case, and the thread is generated into middle text
Shelves, M intermediate document is obtained, wherein the quantity of the thread and the quantity of the intermediate document correspond, 50≤N≤150,
M≤30, and quantity L≤4 of the thread run simultaneously；
S160, M intermediate document merged, obtain the Word tests that the Excel test cases form is completely converted into
Use-case form.
The method that Excel test cases form provided by the invention is converted to Word test case forms, by self-defined
Excel test case forms write template, are write in Excel test case forms and use-case is write in template, then pass through statistics
The quantity of use-case, and use-case is created to the thread for being converted to Word test case forms, thread is generated into intermediate document, it is final logical
Cross and merge the Word test case forms that the intermediate document acquisition Excel test cases form is completely converted into.The present invention carries
The method that the Excel test case forms of confession are converted to Word test case forms, by using the mode of thread process, parallel
Carry out the conversion of use-case form, efficiently improve the switching rate that Excel test case forms are converted to Word test case forms,
And it is easy to operate, securely and reliably.
It is understood that in order to ensure the efficiency of running background and stability, it is necessary to the line for limiting while running
The quantity L of journey, i.e. L≤4.
As a kind of specifically embodiment, as shown in Fig. 2 self-defined Excel test cases table described in step S110
Lattice, which write template and MDB file configuration informations table, can specifically include：
S111, the mark for terminating null as single use-case in template is write in the Excel test cases form；
S112, write the Column Properties information that the Excel test cases form writes template；
S113, the line number in the MDB file configuration informations table and row number are corresponded into the Excel test cases form write mould
Row number in plate.
As another specifically embodiment, as shown in figure 3, the statistics Excel test cases described in step S140
Use-case quantity in form can specifically include：
S141, the number of non-mentioned null cell in " use-case mark " row of the Excel test cases form is set as testing and used
The total number of example；
S142, the number for counting the use-case successively from the top down.
Further specifically, it is described that a thread for being converted to Word test case forms will be created per N number of use-case, and will
The thread generates intermediate document, and obtaining M intermediate document includes：
According to the number of the use-case of statistics, judge whether the number of the use-case is less than N；
If the number of the use-case is less than N, all use-cases are created into a thread for being converted to Word test case forms, and
The thread is generated into an intermediate document, obtains an intermediate document；
If the number of the use-case is more than N, judge the use-case number whether the integral multiple for being N；
If the number of the use-case is N integral multiple, Word test case forms are converted to by creating one per N number of use-case
Thread, and each thread for being converted to Word test case forms is generated into an intermediate document, obtain M intermediate document；
If the number of the use-case is not N integral multiple, one will be created per N number of use-case and be converted to Word test case forms
Thread, by remaining use-case create a thread for being converted to Word test case forms, and by it is each be converted to Word survey
The thread of example form on probation generates an intermediate document, obtains M intermediate document.
Preferably, each thread includes Excel test cases form initial row corresponding to each use-case, Excel tests
Use-case form end line and thread id information.
Preferably, the title of the M intermediate document generates the order of the intermediate document according to each thread
Name.
Preferably, described merge M intermediate document is beaten successively including the establishment order according to each thread
The intermediate document is opened to merge.
As another, specifically embodiment, methods described are additionally included in described obtain the Excel test cases
Form writes template and writes what is carried out before the Excel test case table steps obtained after use-case：
Self-defined Word test cases form template.
By self-defined Word test cases form template, user can be caused to carry out a variety of patterns according to the demand of oneself
Selection, meet user in Word document to the diversified demand of the pattern of form.
Word test case forms are converted to Excel test cases form provided by the invention with reference to Fig. 4 to Fig. 6
The embodiment of method be described in detail.
In order to realize that Word test cases form template and Excel test cases write the self-defined of template, efficiently lifting
The switching rate of document, specifically comprises the following steps：
Step 1, self-defined Word test cases form template, Excel test case forms write template and MDB file configurations
Information table.
Specifically, Fig. 4 is that test case writes template, the mark terminated using null as single use-case；Fig. 5 is to make by oneself
Adopted test case form template, the Column Properties information write in template need to be included；Fig. 6 is the MDB file configuration informations that need to be configured
Table, the line number and row number of MDB file configuration information tables correspond to Excel test case forms and write row number in template, wherein " name
Claim information " arrange and can not change.If Excel test case forms are write in template without certain a line letter in " name information "
Breath, it is all 0 that can put the line number of MDB file configuration information tables and row number.
Step 2, template is write to the Excel test cases form and writes use-case, obtain Excel test case forms.
Step 3, identification MDB file configuration information tables, and read the information in Excel version test case tables；
Specifically, configuration information table is read into chained list LabelList, and each element in chained list preserves MDB file configurations letter
The row number in line number, row number and Excel test case forms in breath table.Read simultaneously in Excel test case forms
Information, it is put into DataTable, is easy to data search.
Use-case quantity in step 4, statistics Excel test case forms, one is created per N number of use-case and is converted to Word surveys
The thread of example form on probation, generates a intermediate document, 50≤N≤150, it is preferable that N=100, i.e., every 100 use-cases create one
The individual thread for being converted to Word test case forms, generates a intermediate document.
Specifically, open and replicate self-defined Word test cases form template, copy form is into pasting boards；Then according to
According to the information read in Excel test case forms, the number of use-case is counted, every 100 use-cases create a thread；Open
Excel test case forms, total number of the number of non-mentioned null cell as test case during identification " use-case mark " arranges.From upper
Down successively count use-case number, if statistics use-case number be 100 integral multiple or searched last column, create
One thread for being converted to Word test case forms, for generating a intermediate document, and corresponding to 100 use-cases
Excel initial rows, Excel end lines and Thread Id information transmission give the thread for being converted to Word test case forms.This side
Formula can ensure that each form has test case to fill.Simultaneously in order to ensure the stability of form conversion, limitation is together
Shi Yunhang maximum thread amount is 4.
Each thread for being converted to Word test case forms is generated into a intermediate document, and ordered by thread order
Name.It is understood that it is to correspond to be converted to the quantity of thread of Word test case forms and the quantity of intermediate document
, obtain M intermediate document, M≤30, because the maximum quantity for the thread for being converted to Word test case forms is 4.
100 self-defined Word test cases form templates are pasted to document, then choose form successively, according to identification
MDB file configuration information tables, the content in Excel test case forms are replicated to choosing in form respective cells, until 100
Individual use-case converts.
Specifically, a newly-built Word document, and 100 self-defined test case form templates are pasted into document.Time
Each form is gone through, the row where " use-case mark " row for beginning look for corresponding to the form from Excel initial rows.According to chained list
LabelList, replicate table row number in content to the corresponding form of the Excel row numbers corresponding to the row, table row number corresponding unit
In lattice.One test may include multiple input steps, need to travel through " input step ", " anticipated output ", " actual result " and " knot
By（Substep performs）", using null as terminating, and added line behind self-defined test case form, above- mentioned information is inserted
In corresponding cell.100 form traversals are completed or search Excel end lines, then in a manner of " middle+ Thread Ids "
Store intermediate document.
Step 5, intermediate document merge.
Specifically, intermediate document is opened successively according to thread order to merge.
When it is implemented, a newly-built Word document, opens and replicates the content in " middle+ Thread Ids " document successively
Into new document, finally preserved according to self-defined title.
The method that Excel test cases form provided by the invention is converted to Word test case forms, can be self-defined
Word test cases form template, Excel test case forms write template, using every 100 use-cases one thread of generation
Mode, 4 threads can be at most run simultaneously and test case form is changed, effectively lift the conversion speed of document.Each
A intermediate document named with " middle+ Thread Ids " of thread generation, and operation, the party are finally merged to intermediate document
Method is presented to client in the form of interface, and wide adaptation range is easy to operate, securely and reliably.
As the second aspect of the invention, there is provided a kind of Excel test cases form is converted to Word test case tables
The device of lattice, wherein, as shown in fig. 7, described device 10 includes：
Custom block 110, the custom block 110 write template and MDB for self-defined Excel test cases form
File configuration information table, wherein the Excel test cases form, which writes template, includes Column Properties information, the MDB files
Line number and row number in configuration information table correspond to the Excel test cases form and write row number in template；
The Excel test cases form is write template for acquisition and writes use by acquisition module 120, the acquisition module 120
The Excel test case forms obtained after example；
Read module 130, the read module 130 is used to read the Excel test cases form, and is stored in DataTable
In, while the MDB file configuration informations table is read into chained list LabelList, each member in the chained list LabelList
It is corresponding described in the plain line number stored in the MDB file configuration informations table, row number and the MDB file configuration informations
Row number in Excel test case forms；
Statistical module 140, the statistical module 140 are used to count the use-case quantity in the Excel test cases form；
Creation module 150, the creation module 150 are used to that establishment one Word test case forms will to be converted to per N number of use-case
Thread, and the thread is generated into intermediate document, M intermediate document is obtained, wherein the quantity of the thread and the centre are literary
The quantity of shelves corresponds, 50≤N≤150, M≤30, and quantity L≤4 of the thread run simultaneously；
Modular converter 160, the modular converter 160 are used to merge M intermediate document, obtain the Excel tests and use
The Word test case forms that example form is completely converted into.
Excel test cases form provided by the invention is converted to the device of Word test case forms, by self-defined
The self-defined Excel test cases form of module writes template, and acquisition module is got writes template in Excel test case forms
On write the Excel test case forms that use-case obtains, then by the quantity of statistical module counts use-case, and by creating mould
Block creates use-case the thread for being converted to Word test case forms, thread is generated into intermediate document, eventually through modular converter
Merge intermediate document and obtain the Word test case forms that the Excel test cases form is completely converted into.The present invention provides
Excel test case forms be converted to the devices of Word test case forms, by using the mode of thread process, open parallel
The conversion of use-case form is opened up, efficiently improves the switching rate that Excel test case forms are converted to Word test case forms, and
It is easy to operate, securely and reliably.
As one kind, specifically embodiment, the custom block 110 are additionally operable to self-defined Word test cases form
Template.
It is understood that the principle that embodiment of above is intended to be merely illustrative of the present and the exemplary implementation that uses
Mode, but the invention is not limited in this.For those skilled in the art, the essence of the present invention is not being departed from
In the case of refreshing and essence, various changes and modifications can be made therein, and these variations and modifications are also considered as protection scope of the present invention.
Claims (10)
1. a kind of method that Excel test cases form is converted to Word test case forms, it is characterised in that methods described bag
Include：
Self-defined Excel test cases form writes template and MDB file configuration information tables, wherein Excel tests are used
Example form, which writes template, includes Column Properties information, described in the line number and row number correspondence in the MDB file configuration informations table
Excel test case forms write the row number in template；
Obtain and the Excel test cases form is write into template write the Excel test case forms that are obtained after use-case；
The Excel test cases form is read, and is stored in DataTable, while reads the MDB file configuration informations table
Into chained list LabelList, each element in the chained list LabelList is stored in the MDB file configuration informations table
Line number, the row number in row number and the MDB file configuration informations in the corresponding Excel test cases form；
Count the use-case quantity in the Excel test cases form；
A thread for being converted to Word test case forms will be created per N number of use-case, and the thread is generated into intermediate document, is obtained
M intermediate document is obtained, wherein the quantity of the thread and the quantity of the intermediate document correspond, 50≤N≤150, M≤
30, and quantity L≤4 of the thread run simultaneously；
M intermediate document is merged, obtains the Word test case tables that the Excel test cases form is completely converted into
Lattice.
2. according to the method for claim 1, it is characterised in that the self-defined Excel test cases form writes template
And MDB file configuration information tables include：
The mark for terminating null as single use-case in template is write in the Excel test cases form；
Write the Column Properties information that the Excel test cases form writes template；
Line number in the MDB file configuration informations table and row number are corresponded into the Excel test cases form to write in template
Row number.
3. according to the method for claim 1, it is characterised in that the use in the statistics Excel test cases form
Number of cases amount includes：
The number of non-mentioned null cell in " use-case mark " row of the Excel test cases form is set as the total of test case
Number；
Count the number of the use-case successively from the top down.
4. according to the method for claim 3, it is characterised in that described establishment one to be converted to Word surveys per N number of use-case
The thread of example form on probation, and the thread is generated into intermediate document, obtaining M intermediate document includes：
According to the number of the use-case of statistics, judge whether the number of the use-case is less than N；
If the number of the use-case is less than N, all use-cases are created into a thread for being converted to Word test case forms, and
The thread is generated into an intermediate document, obtains an intermediate document；
If the number of the use-case is more than N, judge the use-case number whether the integral multiple for being N；
If the number of the use-case is N integral multiple, Word test case forms are converted to by creating one per N number of use-case
Thread, and each thread for being converted to Word test case forms is generated into an intermediate document, obtain M intermediate document；
If the number of the use-case is not N integral multiple, one will be created per N number of use-case and be converted to Word test case forms
Thread, by remaining use-case create a thread for being converted to Word test case forms, and by it is each be converted to Word survey
The thread of example form on probation generates an intermediate document, obtains M intermediate document.
5. according to the method for claim 4, it is characterised in that each thread includes Excel corresponding to each use-case and surveyed
Example form initial row, Excel test case form end lines and thread id information on probation.
6. according to the method for claim 5, it is characterised in that the title of the M intermediate document is according to each described
Thread generates the order name of the intermediate document.
7. according to the method for claim 4, it is characterised in that described to merge M intermediate document including according to every
The establishment order of the individual thread is opened the intermediate document and merged successively.
8. method as claimed in any of claims 1 to 7, it is characterised in that methods described is additionally included in described obtain
Take to write the Excel test cases form before template writes the Excel test case table steps obtained after use-case and carry out
's：
Self-defined Word test cases form template.
9. a kind of Excel test cases form is converted to the device of Word test case forms, it is characterised in that described device bag
Include：
Custom block, the custom block writes template for self-defined Excel test cases form and MDB files are matched somebody with somebody
Information table is put, wherein the Excel test cases form, which writes template, includes Column Properties information, the MDB file configurations letter
Line number and row number in breath table correspond to the Excel test cases form and write row number in template；
Acquisition module, the acquisition module, which is used to obtain to write the Excel test cases form after template writes use-case, to be obtained
The Excel test case forms arrived；
Read module, the read module is used to read the Excel test cases form, and is stored in DataTable, simultaneously
The MDB file configuration informations table is read into chained list LabelList, each element in the chained list LabelList is deposited
Store up line number in the MDB file configuration informations table, the corresponding Excel in row number and the MDB file configuration informations
Row number in test case form；
Statistical module, the statistical module are used to count the use-case quantity in the Excel test cases form；
Creation module, the creation module are used to that a thread for being converted to Word test case forms will to be created per N number of use-case,
And the thread is generated into intermediate document, M intermediate document is obtained, wherein the quantity of the thread and the quantity of the intermediate document
Correspond, 50≤N≤150, M≤30, and quantity L≤4 of the thread run simultaneously；
Modular converter, the modular converter are used to merge M intermediate document, obtain the Excel test cases form
The Word test case forms being completely converted into.
10. device according to claim 9, it is characterised in that the custom block is additionally operable to self-defined Word tests
Use-case form template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710935796.3A CN107679027B (en) | 2017-10-10 | 2017-10-10 | Method and device for converting Excel test case table into Word test case table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710935796.3A CN107679027B (en) | 2017-10-10 | 2017-10-10 | Method and device for converting Excel test case table into Word test case table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107679027A true CN107679027A (en) | 2018-02-09 |
| CN107679027B CN107679027B (en) | 2021-03-19 |
Family
ID=61140169
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710935796.3A Active CN107679027B (en) | 2017-10-10 | 2017-10-10 | Method and device for converting Excel test case table into Word test case table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107679027B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110609990A (en) * | 2019-09-06 | 2019-12-24 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| CN102622334A (en) * | 2012-04-20 | 2012-08-01 | 北京信息科技大学 | Parallel XSLT (Extensible Style-sheet Language Transformation) conversion method and device for use in multi-thread environment |
| US20120265759A1 (en) * | 2011-04-15 | 2012-10-18 | Xerox Corporation | File processing of native file formats |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN106844307A (en) * | 2017-01-05 | 2017-06-13 | 上海核工程研究设计院 | It is a kind of to realize that Excel turns the system and method for Word based on mark |
-
2017
- 2017-10-10 CN CN201710935796.3A patent/CN107679027B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| US20120265759A1 (en) * | 2011-04-15 | 2012-10-18 | Xerox Corporation | File processing of native file formats |
| CN102622334A (en) * | 2012-04-20 | 2012-08-01 | 北京信息科技大学 | Parallel XSLT (Extensible Style-sheet Language Transformation) conversion method and device for use in multi-thread environment |
| CN104484419A (en) * | 2014-12-17 | 2015-04-01 | 上海斐讯数据通信技术有限公司 | Test case document conversion system and test case document conversion method |
| CN106844307A (en) * | 2017-01-05 | 2017-06-13 | 上海核工程研究设计院 | It is a kind of to realize that Excel turns the system and method for Word based on mark |
Non-Patent Citations (1)
| Title |
|---|
| 张亮: "基于Excel VBA 的文书快速生成工具", 《电脑知识与技术》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110609990A (en) * | 2019-09-06 | 2019-12-24 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
| CN110609990B (en) * | 2019-09-06 | 2023-02-07 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107679027B (en) | 2021-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| DAËËOW et al. | On the power of membrane computing | |
| CN108427556A (en) | A kind of form design analytic method and system | |
| CN109460219A (en) | The method of rapid serial Interface Control File | |
| CN106095673A (en) | Automated testing method based on WEB interface and system | |
| CN102667696A (en) | System and method for object relationship identification in a user interface | |
| CN109684387B (en) | Report generation method and device | |
| CN106469215B (en) | Data importing method and system based on webpage end | |
| Althoff et al. | Observations on determinization of Büchi automata | |
| CN110837471B (en) | Test method, test device, server and storage medium | |
| CN105158673B (en) | A kind of generation method and device of ATE boards file | |
| CN108984868B (en) | Method and device for integrating board card internet data | |
| CN110377566A (en) | Arrange the method and system of the S parameter test file of PCB | |
| CN107679027A (en) | Excel test case forms are converted to the method and device of Word test case forms | |
| US8038449B2 (en) | System and method for generating an exam | |
| CN107463368A (en) | A kind of static and dynamic man-machine interface automatic generation method | |
| CN107368414A (en) | Information processing method, device and electronic equipment | |
| CN106802778A (en) | A kind of Intelligent printing method and system | |
| CN107038110A (en) | The method and system of white-box testing | |
| CN115562979A (en) | Method for automatically generating test report based on artificial intelligence | |
| CN109242403A (en) | A kind of demand management method and computer equipment | |
| CN109976719A (en) | A kind of design method of management system, electronic equipment, storage medium and platform | |
| CN102339342B (en) | Quick materialization method of parameterized device unit | |
| US8156395B2 (en) | Methods for generating test patterns for sequential circuits | |
| CN104572457B (en) | A kind of method transformed the non-universal finite state machine containing special transfer process | |
| CN106844447A (en) | The processing method and processing unit of nuclear power station alarm card |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |