An Approach of Test Case Generation for Spreadsheet Cells

摘要

Spreadsheet is one of the most commonly programming environment, widely adopted for data processing, template building and decision making. However, using spreadsheet often leads to serious consequences because of all kinds of errors in it. This paper presents a tool for test case generation based on data mutation and code smells. Including two steps, detecting sheets types and spreadsheet cells test cases generation. And we perform an experiment with our method, the result demonstrates the effectiveness of our test case generation method. At last, the future work of spreadsheet debugging technology is proposed.