CN113900562A - Excel-based testing method and device and storage medium - Google Patents
Excel-based testing method and device and storage medium Download PDFInfo
- Publication number
- CN113900562A CN113900562A CN202111497029.1A CN202111497029A CN113900562A CN 113900562 A CN113900562 A CN 113900562A CN 202111497029 A CN202111497029 A CN 202111497029A CN 113900562 A CN113900562 A CN 113900562A
- Authority
- CN
- China
- Prior art keywords
- target
- test
- excel
- parameter
- values
- 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
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04847—Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (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 test method, a test device and a storage medium based on Excel, relates to the technical field of test, and solves the problem that the graphical user interface of test software in the prior art is poor in universality. The specific scheme comprises the following steps: displaying a graphical user interface, the graphical user interface including a target form; acquiring a target test script associated with a target table, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1; acquiring M target parameter names and at least one group of parameter values at preset positions of a target table, wherein the group of parameter values comprises N values, the N values correspond to N parameter names in the M target parameter names one by one, and N is an integer which is greater than or equal to 1 and less than or equal to M; generating a test condition based on the M target parameter names and the at least one group of parameter values; and executing the target test script according to the test conditions to generate a first result.
Description
Technical Field
The invention relates to the technical field of testing, in particular to a testing method and device based on Excel and a storage medium.
Background
Product testing, which is the final review of product demand analysis and design specification description before the product is put into operation, is a key step in ensuring product quality.
However, in the prior art, when performing product testing, a Graphical User Interface (GUI) of testing software has limitations, for example, the GUI is a fixed Interface under a specific testing condition, and further, the generality of the GUI is poor.
Disclosure of Invention
The invention provides a test method, a test device and a storage medium based on Excel, and solves the problem that the graphical user interface of test software in the prior art is poor in universality.
In order to achieve the purpose, the invention adopts the following technical scheme:
in a first aspect, the present invention provides an Excel-based test method, including:
displaying a graphical user interface, the graphical user interface including a target form;
acquiring a target test script associated with a target table, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1;
acquiring M target parameter names and at least one group of parameter values at preset positions of a target table, wherein the group of parameter values comprises N values, the N values correspond to N parameter names in the M target parameter names one by one, and N is an integer which is greater than or equal to 1 and less than or equal to M;
generating a test condition based on the M target parameter names and the at least one group of parameter values;
and executing the target test script according to the test conditions to generate a first result.
According to the Excel-based test method provided by the embodiment of the invention, through the target test script, the names of M target parameters and at least one group of parameter values can be obtained, the test condition is generated, and the target test script is executed according to the test condition to generate the first result. The test conditions are generated according to the target test script, the limitation of GUI in test software in the prior art is broken through, and the problem that the graphical user interface of the test software in the prior art is poor in universality is solved.
In a possible implementation manner, the obtaining M names of the target parameters and at least one group of parameter values at the preset position of the target table includes:
responding to input operation of a user at a preset position, and acquiring M target parameter names and at least one group of parameter values;
alternatively, the first and second electrodes may be,
and importing the M target parameter names in the target test script into a preset position, and responding to the input operation of a user at the preset position to obtain at least one group of parameter values.
In one possible implementation, the graphical user interface includes a run button;
the executing the target test script according to the test condition to generate the first result includes:
and responding to the clicking operation of the user on the running button, executing the target test script according to the test condition, and generating a first result.
In a possible implementation manner, the executing the target test script according to the test condition to generate the first result includes:
traversing M target parameter names and at least one group of parameter values in the test condition;
generating a second result based on the target set of parameter values if the target set of parameter values includes M values, the target set of parameter values being one of the at least one set of parameter values;
and if the target group parameter values comprise N values and N is less than M, ending the traversal and generating a first result according to all the second results.
In one possible implementation, the graphical user interface includes a script retrieval button;
the obtaining of the target test script associated with the target form includes:
responding to the click operation of a user on a script acquisition button, and displaying a script selection list, wherein the script selection list comprises at least one test script;
and responding to the selection operation of the user in the script selection list, and acquiring the target test script.
In a second aspect, the present invention provides an Excel-based test apparatus, including:
a display unit for displaying a graphical user interface, the graphical user interface including a target form;
the acquisition unit is used for acquiring a target test script associated with a target table in the display unit, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1; the system is also used for acquiring M target parameter names and at least one group of parameter values at preset positions of a target table, wherein the group of parameter values comprises N values, the N values are in one-to-one correspondence with N parameter names in the M target parameter names, and N is an integer which is greater than or equal to 1 and less than or equal to M;
the generating unit is used for generating a test condition based on the M target parameter names and at least one group of parameter values in the acquiring unit; and the target test script is executed according to the test condition to generate a first result.
In a possible implementation manner, the obtaining unit is specifically configured to:
responding to input operation of a user at a preset position, and acquiring M target parameter names and at least one group of parameter values;
alternatively, the first and second electrodes may be,
and importing the M target parameter names in the target test script into a preset position, and responding to the input operation of a user at the preset position to obtain at least one group of parameter values.
In one possible implementation, the graphical user interface includes a run button;
the generating unit is specifically configured to:
and responding to the clicking operation of the user on the running button, executing the target test script according to the test condition, and generating a first result.
In a possible implementation manner, the generating unit is specifically configured to:
traversing M target parameter names and at least one group of parameter values in the test condition;
generating a second result based on the target set of parameter values if the target set of parameter values includes M values, the target set of parameter values being one of the at least one set of parameter values;
and if the target group parameter values comprise N values and N is less than M, ending the traversal and generating a first result according to all the second results.
In one possible implementation, the graphical user interface includes a script retrieval button;
the obtaining unit is specifically configured to:
responding to the click operation of a user on a script acquisition button, and displaying a script selection list, wherein the script selection list comprises at least one test script;
and responding to the selection operation of the user in the script selection list, and acquiring the target test script.
In a third aspect, the present invention provides an Excel-based test apparatus, including: a processor and a memory. The memory is for storing computer program code, the computer program code including computer instructions. When the processor executes the computer instructions, the Excel-based testing apparatus performs the Excel-based testing method as described in the first aspect and any possible implementation manner thereof.
In a fourth aspect, the present invention provides a storage medium having stored thereon computer instructions, which, when run on an Excel-based test apparatus, cause the Excel-based test apparatus to execute the Excel-based test method according to the first aspect or any one of the possible implementation manners of the first aspect.
Drawings
Fig. 1 is a schematic structural diagram of a terminal device according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of an Excel-based testing method according to an embodiment of the present invention;
FIG. 3 is a second schematic flow chart of an Excel-based testing method according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an Excel-based test apparatus according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the following, the terms "first", "second" are used for descriptive purposes only and are not to be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the embodiments of the present disclosure, "a plurality" means two or more unless otherwise specified.
Additionally, the use of "based on" or "according to" means open and inclusive, as a process, step, calculation, or other action that is "based on" or "according to" one or more stated conditions or values may in practice be based on additional conditions or exceeding the stated values.
In order to solve the problem of poor generality of a graphical user interface of test software in the prior art, the embodiment of the invention provides a test method, a test device and a storage medium based on Excel. Through the target test script, M target parameter names and at least one group of parameter values can be obtained, so that a test condition is generated, the target test script is executed according to the test condition, and a first result is generated. The test conditions are generated according to the target test script, the limitation of GUI of the test software in the prior art is broken through, and the problem that the graphical user interface of the test software in the prior art is poor in universality is solved.
The Excel-based test method provided by the embodiment of the invention can be suitable for an Excel-based test system, and the Excel-based test system can comprise terminal equipment.
Optionally, an Excel client is installed in the terminal device, and a document may be generated in advance by the Excel client, where the format of the document is an Excel format. In response to a click operation of the document by the user, the terminal device may display a graphical user interface and display a target table in the graphical user interface, and the target table may include a plurality of cells.
For example, the terminal device may be a smartphone, a tablet computer, or a desktop computer, which is not limited herein.
The hardware structure of the terminal device will be described below by taking the terminal device shown in fig. 1 as an example.
As shown in fig. 1, the terminal device may include: a processor 11, a memory 12, a communication interface 13 and a bus 14. The processor 11, the memory 12 and the communication interface 13 may be connected by a communication bus 14.
The processor 11 is a control center of the computing device, and may be one processor 11 or a collective term for a plurality of processing elements. For example, the processor 11 may be a general-purpose Central Processing Unit (CPU), or may be another general-purpose processor 11. The general purpose processor 11 may be a microprocessor 11 or any conventional processor 11 or the like.
For one embodiment, processor 11 may include one or more CPUs, such as CPU0 and CPU1 shown in FIG. 1.
The memory 12 may be, but is not limited to, a read-only memory 12 (ROM) or other type of static storage device that may store static information and instructions, a random access memory 12 (RAM) or other type of dynamic storage device that may store information and instructions, an electrically erasable programmable read-only memory 12 (EEPROM), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer.
In a possible implementation, the memory 12 may be present separately from the processor 11, and the memory 12 may be connected to the processor 11 via a bus 14 for storing instructions or program code. The Excel-based test method provided in the following embodiments of the present application can be implemented when the processor 11 calls and executes the instructions or program codes stored in the memory 12.
In another possible implementation, the memory 12 may also be integrated with the processor 11.
The communication interface 13 is used for connecting the computing apparatus and other devices through a communication network, where the communication network may be an ethernet, a Radio Access Network (RAN), a Wireless Local Area Network (WLAN), or the like. The communication interface 13 may comprise a receiving unit for receiving data and a transmitting unit for transmitting data.
The bus 14 may be an Industry Standard Architecture (ISA) bus 14, a Peripheral Component Interconnect (PCI) bus 14, an Extended ISA (EISA) bus 14, or the like. The bus 14 may be divided into an address bus 14, a data bus 14, a control bus 14, etc. For ease of illustration, only one thick line is shown in FIG. 1, but does not indicate only one bus 14 or one type of bus 14.
It is noted that the configuration shown in fig. 1 does not constitute a limitation of the terminal device, which may comprise more or less components than those shown in fig. 1, or some components may be combined, or a different arrangement of components than those shown in fig. 1.
The execution main body of the Excel-based test method provided by the embodiment of the invention is an Excel-based test device. The Excel-based test device can be the terminal equipment or a CPU in the terminal equipment. The embodiment of the invention takes the terminal equipment executing the Excel-based test method as an example, and explains the Excel-based test method provided by the application.
The Excel-based test method provided by the embodiment of the invention is described below with reference to the accompanying drawings.
As shown in fig. 2, the Excel-based testing method provided by the embodiment of the present invention includes the following steps 201 to 205.
201. The terminal device displays a graphical user interface including a target form.
The terminal equipment is provided with an Excel client, and a document can be generated by the Excel client in advance, wherein the format of the document is an Excel format. In response to a click operation of the document by the user, the terminal device may display a graphical user interface and display a target table in the graphical user interface, and the target table may include a plurality of cells.
202. The terminal equipment acquires a target test script associated with the target table, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1.
Optionally, the target parameter name may be a name of a parameter required when testing a certain performance of the target product. The target parameter name may include, but is not limited to, voltage, current, or resistance.
Optionally, the graphical user interface includes a script retrieving button. The script retrieving button may be disposed at any position of the target form.
Optionally, the obtaining of the target test script associated with the target table may include the following processes: firstly, the terminal equipment responds to the click operation of a user on a script acquisition button, and displays a script selection list, wherein the script selection list comprises at least one test script. Then, the terminal device responds to the selection operation of the user in the script selection list to obtain the target test script.
203. The terminal equipment obtains M target parameter names and at least one group of parameter values at preset positions of a target table, wherein the group of parameter values comprises N values, the N values are in one-to-one correspondence with N parameter names in the M target parameter names, and N is an integer which is greater than or equal to 1 and less than or equal to M.
204. The terminal equipment generates a test condition based on the M target parameter names and at least one group of parameter values.
205. And the terminal equipment executes the target test script according to the test conditions to generate a first result.
Optionally, the graphical user interface may further include a run button. The run button may be provided at any position of the target table.
Optionally, the executing, by the terminal device, the target test script according to the test condition to generate the first result may include: and the terminal equipment responds to the clicking operation of the user on the operation button, executes the target test script according to the test condition and generates a first result.
Optionally, the executing, by the terminal device, the target test script according to the test condition to generate the first result may include the following processes: first, the terminal device traverses M target parameter names and at least one set of parameter values in the test condition. Next, if the target set of parameter values includes M values, the terminal device generates a second result based on the target set of parameter values, the target set of parameter values being a set of values of the at least one set of parameter values. And finally, if the target group parameter values comprise N values and N is less than M, ending the traversal and generating a first result according to all the second results.
It should be understood that, when the number of target parameter values of a target group is less than the number of target parameter names, the traversal is terminated, which indicates that the terminal device has completed the performance test of the target product.
According to the Excel-based test method provided by the embodiment of the invention, the names of M target parameters and at least one group of parameter values can be acquired through the target test script, so that the test condition is generated, and the target test script is executed according to the test condition to generate the first result. The test conditions are generated according to the target test script, the limitation of GUI in test software in the prior art is broken through, and the problem that the graphical user interface of the test software in the prior art is poor in universality is solved.
Referring to fig. 2, as shown in fig. 3, the step 203 may specifically include the following step 301 or step 302, where the terminal device obtains M target parameter names and at least one set of parameter values at preset positions of the target table.
301. The terminal equipment responds to the input operation of a user at a preset position, and obtains M target parameter names and at least one group of parameter values.
It should be understood that, in the case where the terminal device acquires M target parameter names in response to the input operation of the user at the preset position, an error may occur in any one of the target parameter names at the preset position. Therefore, when the terminal device executes the target test script according to the M target parameter names in the test condition, the M target parameter names need to be determined. And when any target parameter name at the preset position is not matched with any target parameter name in the M target parameter names in the target test script, ending the traversal.
302. The terminal device may import M target parameter names in the target test script into a preset location, and obtain at least one set of parameter values in response to an input operation of a user at the preset location.
The terminal equipment leads M target parameter names in the target test script into the preset position, accuracy of the target parameter names in the test conditions can be guaranteed, and then test efficiency can be improved.
The scheme provided by the embodiment of the invention is mainly introduced from the perspective of an Excel-based testing device. It is understood that, in order to implement the above functions, the Excel-based test device includes a hardware structure and/or a software module corresponding to each function. Those of skill in the art will readily appreciate that the present invention can be implemented in hardware or a combination of hardware and computer software, in conjunction with the exemplary algorithm steps described in connection with the embodiments disclosed herein. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
Fig. 4 shows a schematic diagram of a possible composition of the Excel-based test apparatus 400 involved in the above embodiments, and as shown in fig. 4, the Excel-based test apparatus 400 may include: a display unit 401, an acquisition unit 402, and a generation unit 403.
The display unit 401 is configured to display a graphical user interface, where the graphical user interface includes a target table. An obtaining unit 402, configured to obtain a target test script associated with the target table in the display unit 401, where the target test script includes M target parameter names, and M is an integer greater than or equal to 1; the method is further used for obtaining M target parameter names and at least one group of parameter values at preset positions of a target table, wherein the group of parameter values comprises N values, the N values are in one-to-one correspondence with the N parameter names in the M target parameter names, and N is an integer which is greater than or equal to 1 and less than or equal to M. A generating unit 403, configured to generate a test condition based on the M target parameter names and the at least one set of parameter values in the obtaining unit 402; and the target test script is executed according to the test condition to generate a first result.
Optionally, the obtaining unit 402 is specifically configured to obtain, in response to an input operation of a user at a preset position, names of M target parameters and at least one group of parameter values. Or, the method is specifically configured to import M target parameter names in the target test script into a preset location, and obtain at least one group of parameter values in response to an input operation of a user at the preset location.
The generating unit 403 is specifically configured to, in response to a click operation of the running button by the user, execute the target test script according to the test condition, and generate a first result.
A generating unit 403, specifically configured to traverse M target parameter names and at least one group of parameter values in the test condition; generating a second result based on the target set of parameter values if the target set of parameter values includes M values, the target set of parameter values being one of the at least one set of parameter values; and if the target group parameter values comprise N values and N is less than M, ending the traversal and generating a first result according to all the second results.
An obtaining unit 402, configured to display a script selection list in response to a click operation of a user on a script obtaining button, where the script selection list includes at least one test script; and responding to the selection operation of the user in the script selection list, and acquiring the target test script.
Of course, the Excel-based test apparatus 400 provided by the embodiment of the present invention includes, but is not limited to, the above modules.
In actual implementation, the display unit 401, the obtaining unit 402, and the generating unit 403 may be implemented by the processor 11 shown in fig. 1 calling program codes in the memory 12. For a specific implementation process, reference may be made to the descriptions of the Excel-based test method portions shown in fig. 2 to fig. 4, which are not described herein again.
Another embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores computer instructions, and when the computer instructions are run on an Excel-based testing apparatus, the Excel-based testing apparatus is enabled to perform the steps performed by the Excel-based testing apparatus in the method flow shown in the foregoing method embodiment.
Another embodiment of the present application further provides a chip system, which is applied to an Excel-based test apparatus. The system-on-chip includes one or more interface circuits, and one or more processors 11. The interface circuit and the processor 11 are interconnected by a line. The interface circuit is configured to receive signals from the memory 12 of the Excel-based test apparatus and to send the signals to the processor 11, the signals comprising computer instructions stored in the memory 12. When the processor 11 executes the computer instructions, the Excel-based test apparatus executes the steps executed by the Excel-based test apparatus in the method flow shown in the above-described method embodiments.
In another embodiment of the present application, a computer program product is further provided, where the computer program product includes instructions that, when executed on an Excel-based test apparatus, cause the Excel-based test apparatus to perform each step performed by the Excel-based test apparatus in the method flow shown in the above method embodiment.
The above description is only an embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions within the technical scope of the present invention are intended to be covered by the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (10)
1. A Excel-based test method is characterized by comprising the following steps:
displaying a graphical user interface, the graphical user interface including a target form;
acquiring a target test script associated with the target table, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1;
acquiring M target parameter names and at least one group of parameter values at preset positions of the target table, wherein the group of parameter values comprises N values, the N values are in one-to-one correspondence with N parameter names in the M target parameter names, and N is an integer which is greater than or equal to 1 and less than or equal to M;
generating a test condition based on the M target parameter names and the at least one set of parameter values;
and executing the target test script according to the test condition to generate a first result.
2. The Excel-based testing method according to claim 1, wherein the obtaining of M target parameter names at preset positions of the target table and at least one set of parameter values comprises:
responding to the input operation of a user at the preset position, and acquiring the names of the M target parameters and the at least one group of parameter values;
alternatively, the first and second electrodes may be,
and importing the M target parameter names in the target test script into the preset position, and responding to the input operation of a user at the preset position to obtain the at least one group of parameter values.
3. The Excel-based testing method in accordance with claim 2 wherein the graphical user interface comprises a run button;
the executing the target test script according to the test condition to generate a first result includes:
and responding to the clicking operation of the user on the running button, executing the target test script according to the test condition, and generating a first result.
4. The Excel-based testing method according to any one of claims 1 to 3, wherein the executing the target test script according to the test condition to generate a first result comprises:
traversing the M target parameter names and the at least one set of parameter values in the test condition;
generating a second result based on a target set of parameter values if the target set of parameter values includes M values, the target set of parameter values being a set of values of the at least one set of parameter values;
and if the target group parameter values comprise N values and N is less than M, ending traversal and generating the first result according to all the second results.
5. An Excel-based testing method in accordance with anyone of claims 1-3 wherein the graphical user interface comprises a script retrieval button;
the obtaining of the target test script associated with the target form includes:
responding to the click operation of a user on the script acquisition button, and displaying a script selection list, wherein the script selection list comprises at least one test script;
and responding to the selection operation of the user in the script selection list, and acquiring the target test script.
6. An Excel-based test device, comprising:
a display unit for displaying a graphical user interface, the graphical user interface including a target form;
the acquisition unit is used for acquiring a target test script associated with a target table in the display unit, wherein the target test script comprises M target parameter names, and M is an integer greater than or equal to 1; the system is further used for obtaining M target parameter names and at least one group of parameter values at preset positions of the target table, wherein the group of parameter values comprises N values, the N values are in one-to-one correspondence with N parameter names in the M target parameter names, and N is an integer which is greater than or equal to 1 and less than or equal to M;
a generating unit, configured to generate a test condition based on the M target parameter names and the at least one group of parameter values in the obtaining unit; and the target test script is executed according to the test condition to generate a first result.
7. The Excel-based testing apparatus according to claim 6, wherein the obtaining unit is specifically configured to:
responding to the input operation of a user at the preset position, and acquiring the names of the M target parameters and the at least one group of parameter values;
alternatively, the first and second electrodes may be,
and importing the M target parameter names in the target test script into the preset position, and responding to the input operation of a user at the preset position to obtain the at least one group of parameter values.
8. The Excel-based testing device in accordance with claim 7, wherein the graphical user interface comprises a run button;
the generating unit is specifically configured to:
and responding to the clicking operation of the user on the running button, executing the target test script according to the test condition, and generating a first result.
9. An Excel-based test device, the Excel-based test device comprising: a processor and a memory; the memory for storing computer program code, the computer program code comprising computer instructions; when the computer instructions are executed by the processor, the Excel-based testing apparatus executes the Excel-based testing method according to any one of claims 1 to 5.
10. A storage medium comprising computer instructions which, when run on an Excel-based testing apparatus, cause the Excel-based testing apparatus to perform the Excel-based testing method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111497029.1A CN113900562A (en) | 2021-12-09 | 2021-12-09 | Excel-based testing method and device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111497029.1A CN113900562A (en) | 2021-12-09 | 2021-12-09 | Excel-based testing method and device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113900562A true CN113900562A (en) | 2022-01-07 |
Family
ID=79025448
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111497029.1A Pending CN113900562A (en) | 2021-12-09 | 2021-12-09 | Excel-based testing method and device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113900562A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114048084A (en) * | 2022-01-11 | 2022-02-15 | 深圳佑驾创新科技有限公司 | Method and device for generating test case schema of schematic diagram and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102215501A (en) * | 2010-04-09 | 2011-10-12 | 希姆通信息技术（上海）有限公司 | Method for realizing automated testing of AT (Automated Testing) command of wireless module |
| CN105912460A (en) * | 2016-04-05 | 2016-08-31 | 浪潮电子信息产业股份有限公司 | Software test method and system based on QTP |
| US20180032427A1 (en) * | 2015-08-11 | 2018-02-01 | American Express Travel Related Services Company, Inc. | Test script configuration spreadsheet |
| CN108399122A (en) * | 2017-02-06 | 2018-08-14 | 北京京东尚科信息技术有限公司 | Test script operation method and system |
| CN110874322A (en) * | 2018-09-04 | 2020-03-10 | 阿里巴巴集团控股有限公司 | Test method and test server for application program |
| CN113064828A (en) * | 2021-04-13 | 2021-07-02 | 广州骏伯网络科技有限公司 | Automatic testing method and device, computer equipment and storage medium |
| CN113392024A (en) * | 2021-07-02 | 2021-09-14 | 中国工商银行股份有限公司 | Method, device, equipment and medium for testing storage process |
-
2021
- 2021-12-09 CN CN202111497029.1A patent/CN113900562A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102215501A (en) * | 2010-04-09 | 2011-10-12 | 希姆通信息技术（上海）有限公司 | Method for realizing automated testing of AT (Automated Testing) command of wireless module |
| US20180032427A1 (en) * | 2015-08-11 | 2018-02-01 | American Express Travel Related Services Company, Inc. | Test script configuration spreadsheet |
| CN105912460A (en) * | 2016-04-05 | 2016-08-31 | 浪潮电子信息产业股份有限公司 | Software test method and system based on QTP |
| CN108399122A (en) * | 2017-02-06 | 2018-08-14 | 北京京东尚科信息技术有限公司 | Test script operation method and system |
| CN110874322A (en) * | 2018-09-04 | 2020-03-10 | 阿里巴巴集团控股有限公司 | Test method and test server for application program |
| CN113064828A (en) * | 2021-04-13 | 2021-07-02 | 广州骏伯网络科技有限公司 | Automatic testing method and device, computer equipment and storage medium |
| CN113392024A (en) * | 2021-07-02 | 2021-09-14 | 中国工商银行股份有限公司 | Method, device, equipment and medium for testing storage process |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114048084A (en) * | 2022-01-11 | 2022-02-15 | 深圳佑驾创新科技有限公司 | Method and device for generating test case schema of schematic diagram and storage medium |
| CN114048084B (en) * | 2022-01-11 | 2022-04-26 | 深圳佑驾创新科技有限公司 | Method and device for generating test case schema of schematic diagram and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108984388B (en) | Method and terminal equipment for generating automatic test case | |
| CN114095567B (en) | Data access request processing method and device, computer equipment and medium | |
| CN112269744A (en) | System abnormity testing method and device, computer equipment and storage medium | |
| CN111797026A (en) | Test case generation method and device, computer equipment and storage medium | |
| WO2015101171A1 (en) | Method, device, and system for updating authentication informatoin | |
| CN112631924A (en) | Automatic testing method and device, computer equipment and storage medium | |
| CN111858296A (en) | Interface test method, device, equipment and storage medium | |
| CN110569984A (en) | configuration information generation method, device, equipment and storage medium | |
| CN105005526A (en) | Information reminding method and mobile terminal | |
| CN113900562A (en) | Excel-based testing method and device and storage medium | |
| CN109788052B (en) | Server configuration remote query method, device, terminal and storage medium | |
| CN112985867B (en) | Steering engine testing method, device, equipment and storage medium | |
| CN108062401B (en) | Application recommendation method and device and storage medium | |
| CN114218072A (en) | Test script generation method and device, storage medium and computer equipment | |
| CN109491909A (en) | A kind of CPLD refreshes verification method, device, terminal and storage medium | |
| CN112988589A (en) | Interface testing method, device and system | |
| CN109697166B (en) | Test data preparation method and related device | |
| CN116545905A (en) | Service health detection method and device, electronic equipment and storage medium | |
| CN112416747A (en) | Test case execution method, device, equipment and medium | |
| CN113901852A (en) | Detection method and device for electronic equipment | |
| CN112073462B (en) | Positioning method and device | |
| CN107623602B (en) | Automatic checking method and system | |
| CN111228815A (en) | Method, apparatus, storage medium, and system for processing configuration table of game | |
| CN111078518A (en) | Data acquisition method, terminal device and computer-readable storage medium | |
| CN115243286B (en) | Data processing method, device and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220107 |