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. Copyright © 2015 for the individual papers by the papers' authors.

Toward reverse engineering of VBA based excel spreadsheet applications / Amalfitano, Domenico; Amatucci, Nicola; DE SIMONE, Vincenzo; Fasolino, ANNA RITA; Tramontana, Porfirio. - 1355:(2015), pp. 30-31. (Intervento presentato al convegno 2nd Workshop on Software Engineering Methods in Spreadsheets, SEMS 2015 tenutosi a Florence; Italy; nel 18 May 2015).

Toward reverse engineering of VBA based excel spreadsheet applications

AMALFITANO, DOMENICO;AMATUCCI, NICOLA;DE SIMONE, VINCENZO;FASOLINO, ANNA RITA;TRAMONTANA, PORFIRIO
2015

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. Copyright © 2015 for the individual papers by the papers' authors.
2015
Toward reverse engineering of VBA based excel spreadsheet applications / Amalfitano, Domenico; Amatucci, Nicola; DE SIMONE, Vincenzo; Fasolino, ANNA RITA; Tramontana, Porfirio. - 1355:(2015), pp. 30-31. (Intervento presentato al convegno 2nd Workshop on Software Engineering Methods in Spreadsheets, SEMS 2015 tenutosi a Florence; Italy; nel 18 May 2015).
File in questo prodotto:
File Dimensione Formato  
sems2015_paper10.pdf

accesso aperto

Tipologia: Documento in Pre-print
Licenza: Accesso privato/ristretto
Dimensione 257.52 kB
Formato Adobe PDF
257.52 kB Adobe PDF Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11588/677592
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 0
  • ???jsp.display-item.citation.isi??? ND
social impact