Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications
Software Engineering
2015-03-12 v1
Abstract
Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult to be maintained or restructured. In this position paper we present in a nutshell two reverse engineering techniques and a tool that we are currently realizing for the abstraction of conceptual data models and business logic models.
Cite
@article{arxiv.1503.03401,
title = {Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications},
author = {Domenico Amalfitano and Nicola Amatucci and Vincenzo De Simone and Anna Rita Fasolino and Porfirio Tramontana},
journal= {arXiv preprint arXiv:1503.03401},
year = {2015}
}
Comments
In Proceedings of the 2nd Workshop on Software Engineering Methods in Spreadsheets (http://spreadsheetlab.org/sems15/)