Excel-Loaded Test Cases for Flexible Script Parameterization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing test systems require frequent program code modifications, leading to tight binding between test system development and program development, dependency on professional script modification, and low efficiency in modifying test logic and parameters.

Innovation Solution

A test method and system based on Excel file loading, allowing testers to edit and execute test cases using an Excel file, with defined columns for test steps, actions, parameters, and annotations, and generating test reports.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If test scripts are implemented in programming languages and frequently modified to meet test requirements, then test logic and parameters can be adapted, but tight binding between test system development and program development occurs, creating dependency on professional script modification and reducing modification efficiency

Engineering Contradiction:

Improvetest logic adaptabilityVSAvoidscript modification ease

Core Design Contradiction:

Adaptability or versatilityVSEase of operation

Solution Approach 1:

The patent introduces an Excel file as an intermediary between the test system and the test script. Instead of directly modifying program code, testers interact with test logic and parameters through Excel files, which are then loaded and executed by the test system. This intermediary layer decouples the test system from direct program modification requirements, allowing non-programmers to easily modify test scripts while maintaining adaptability.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent replaces the traditional mechanical approach of editing and compiling program code with an Excel-based system. Testers use Excel's familiar spreadsheet interface to define and modify test logic, eliminating the need for programming language knowledge and compilation processes. The test system automatically loads and interprets the Excel file contents, substituting the manual code editing mechanism with an automated file-based approach.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Adaptability or versatility

If test scripts are edited by modifying program code, then test logic can be changed, but the process requires professional script modification skills and reduces modification efficiency

Engineering Contradiction:

Improvetest parameter flexibilityVSAvoidscript modification efficiency

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The Excel file serves as an intermediary that bridges test requirements and system execution. Testers can modify test parameters and logic by simply editing Excel cells rather than writing or compiling code. The test system loads these Excel files and automatically processes the test logic, thereby improving productivity by eliminating programming requirements while maintaining full flexibility in test parameter adjustment.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent enables easy parameter changes by storing test parameters in an Excel file format that is inherently designed for parameter management. Testers can modify parameters by changing cell values, adding or removing rows, or adjusting formulas in the Excel file, without needing to understand programming syntax or compilation processes. This dramatically improves modification efficiency while maintaining complete parameter flexibility.

Inventive Principle:

Principle #35Parameter changes

3Adaptability or versatility

If frequent program code modifications are made to adjust test scripts, then test requirements can be met, but tight binding between test system development and program development occurs

Engineering Contradiction:

Improvetest requirement responsivenessVSAvoidsystem coupling complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The Excel file acts as a mediator that decouples the test system from direct program code dependencies. The test system is designed to load and execute test logic from Excel files rather than requiring direct modification of its own program code. This intermediary approach allows the system to respond to test requirements through Excel file changes without creating tight binding between test system development and program development, thereby reducing system coupling complexity.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS20260030149A1Test method, system, and device based on excel file loading cross-reference to related applications

Publication Date: 2026.01.29 SHANGHAI TOSUN TECH LTD

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.