Excel Test Case Loading for Code-Free Script Modification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing test systems require complex programming and are tightly bound to test system development, leading to low efficiency and dependency on professional script modification.
Innovation Solution
A test method and system based on Excel file loading, allowing testers to edit and execute test cases using an Excel file, decoupling test system development from script modification, and enabling parameterization without programming expertise.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If test scripts are implemented in programming languages (C, C#, Python, VB), then test logic can be precisely defined, but the system becomes tightly bound to program development and requires professional script modification
Solution Approach 1:
The patent introduces an Excel file as an intermediary between the test system and the test script. Instead of directly editing programming code, testers modify test parameters and logic through Excel spreadsheets, which are then loaded and executed by the test system. This mediator layer abstracts the complexity of programming while preserving test precision.
Solution Approach 2:
The patent replaces the mechanical system of direct code editing with a spreadsheet-based system. Testers use Excel's familiar grid interface and formulas instead of programming languages, substituting the complex mechanical process of code modification with a simpler, more accessible alternative that maintains test functionality.
2Manufacturing precision
If test scripts are edited and compiled by developers, then test requirements can be accurately implemented, but the efficiency of modifying test logic and parameters decreases
Solution Approach 1:
The Excel file serves as a mediator that enables rapid modification of test logic and parameters without requiring developer intervention. Testers can directly edit test cases in Excel format, which the test system automatically loads and executes, eliminating the time-consuming compilation process while maintaining implementation accuracy.
Solution Approach 2:
The patent enables dynamic parameter changes in test scripts through Excel file modification. Testers can alter test parameters, conditions, and logic by simply changing values in the Excel spreadsheet, and these changes are immediately reflected in the next test execution without requiring re-compilation or re-deployment of the test system.
3Reliability
If professional script modification is required, then test scripts can be precisely controlled, but dependency on professional personnel increases
Solution Approach 1:
The Excel-based test script system acts as an intermediary that empowers testers with direct control over test logic modification. Instead of relying on developers as intermediaries, testers use Excel's accessible interface to independently modify and control test scripts, maintaining precision while increasing their autonomy and versatility.
Data Source
AI summary
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.