Back to results
US 2026/0030149 A1Published application
Test method, system, and device based on excel file loading cross-reference to related applications
AssigneeShanghai Tosun Technology Ltd.
InventorsChu LIU, Yueyin Xie, Mang Mo
Life of this patent
Estimating the term…
Abstract
A test method based on Excel file loading includes: editing an Excel test case; and testing the Excel test case. In this way, a test script is implemented based on an Excel file, and it is only required to modify the Excel file to modify the test script, thereby preventing a program from being frequently modified in a process of changing the script, and improving a parameterization capability of a test system.
Claims14
A method for editing an Excel test case, comprising:
- using a test case viewing and editing device to create an Excel file, load the Excel file, display detailed information of the Excel test case, and edit the Excel test case, wherein when an Excel program is started, the Excel file created by using the test case viewing and editing device is opened, wherein each sheet of the Excel file is a test case, and each test case comprises an Excel test step column, an Excel name column, an Excel description column, an Excel execution action column, an Excel operation content column, an Excel parameter column, and an Excel annotation column;
- wherein
- the Excel test step column in the Excel file sequentially defines an identifier of a step of a current test case;
- the Excel name column in the Excel file defines a displayed name of the step;
- the Excel description column in the Excel file defines a descriptive text of a current step, and the descriptive text is displayed in the test case viewing and editing device;
- the Excel execution action column in the Excel file defines a specific action to be executed by a test system for the current step;
- the Excel operation content column in the Excel file defines content information for action execution of the current step;
- the Excel parameter column in the Excel file defines parameter information, and the action execution of the current step depends on the parameter information;
- and
- the Excel annotation column in the Excel file defines annotative information of the current step.
7 more elements
A method for testing an Excel test case, comprises:
- executing an Excel test case by using a test case executor, writing a test result into an Excel result file in an execution process, and generating a test report, wherein
- during running, the test case executor loads and displays content of the Excel file, executes test cases one by one, displays the test result, and generates the test report successively;
- after the Excel test case is tested, the Excel program displays the test report after being started, wherein a test report file comprises a plurality of sheets, and each of the sheets represents a report of one test case;
- and
- each report comprises a test result column, an Excel test step column, an Excel name column, an Excel description column, an Excel execution action column, an Excel operation content column, an Excel parameter column, and an Excel annotation column.
2 more elements
Dependencies are inferred from the claim text.