i-nth logo

Authors

Nysret Musliu, Wolfgang Slany, & Johannes Gartner

Abstract

Generation of test cases for end-user programmers is crucial to assure the correctness of their code.

In this paper we investigate the automatic generation of test cases for programs that are written in Visual Basic for Applications and are used in MS Excel. We implement a metaheuristic search method to generate tests that achieve a satisfactory statement and branch coverage. Furthermore, in our methodology the code coverage is visualized.

The generated test cases and the visualization enable end users to better understand the behavior of the programs and increase the probability of detecting errors when the code is changed at a later time.

Sample

Meta heuristic for automatic generation of test cases
Meta heuristic for automatic generation of test cases

Our heuristic based procedure starts from a random solution. The current solution is further improved until all statements/branches are covered or the maximum number of iterations is reached.

Publication

2013, Lecture Notes in Computer Science, Volume 7897, June, pages 272-277

Full article

Automated test case generation in end-user programming