Automatically extracting class diagrams from spreadsheets

Automatically extracting class diagrams from spreadsheets

Hermans, F.
Pinzger, M.
Van Deursen, A.

Electrical Engineering, Mathematics and Computer Science

Software Technology

2010-12-31

The use of spreadsheets to capture information is widespread in industry. Spreadsheets can thus be a wealthy source of domain information. We propose to automatically extract this information and transform it into class diagrams. The resulting class diagram can be used by software engineers to understand, refine, or re-implement the spreadsheet’s functionality. To enable the transformation into class diagrams we create a library of common spreadsheet usage patterns. These patterns are localized in the spreadsheet using a two- dimensional parsing algorithm. The resulting parse tree is transformed and enriched with information from the library. We evaluate our approach on the spreadsheets from the Euses Spreadsheet Corpus by comparing a subset of the generated class diagrams with reference class diagrams created manually. Preprint accepted for publication in Proceedings of the 24th European Conference on Object-Oriented Programming (ECOOP 2010), Maribor (Slovenija), 21-25 June 2010, Lecture Notes in Computer Science, Springer-Verlag, 2010.

http://resolver.tudelft.nl/uuid:09d080de-5b70-4957-a564-380ff58c99ba

Delft University of Technology, Software Engineering Research Group

1872-5392

Technical Report Series TUD-SERG-2010-013

Institutional Repository

lecture notes

© 2010 The Author(s) . Software Engineering Research Group, Department of Software Technology, Faculty of Electrical Engineering, Mathematics and Computer Science, Delft University of Technology