This paper introduces an innovative no-code methodology called QUALITY for automated test generation utilizing Excel templates for unit and integration testing. The suggested method allows non-technical stakeholders to engage in test creation while upholding software quality standards. Utilizing familiar Excel interface enables enterprises to lower the entry barriers for test automation and enhance test coverage among development teams. This technique connects business requirements with technical testing, thereby expediting software delivery while ensuring quality assurance. • No-Code Test Generation: QUALITY transforms Excel-based templates into operational API unit and integration tests without necessitating programming proficiency. • Multi-Protocol Support: QUALITY provides native support for REST, SOAP, and GraphQL, facilitating cohesive testing across many API environments. • Template-Driven Maintainability: Test cases can be modified or expanded effortlessly by adjusting spreadsheet rows, hence minimizing maintenance burdens. • Integration and Reporting: QUALITY facilitates dependency-aware execution, CI/CD integration (maven supported), and produces comprehensive HTML, CSV, Console Logs and Extent reports for actionable insights.
Patel et al. (Sun,) studied this question.