Smalltalk as a Converter of Excel Spreadsheets

In the real life of business people Excel spreadsheets play an important role. They are easy to create, easy to modify, easy to deliver. Copy – Paste – modify is the standard Excel (programming) activity. Cells named by row and column represent the data model (or object model if you prefer). This is easy and absolutely not scalable. In my personal real life as manager of my company I have Excel spreadsheets as everybody else. And I have to consolidate them, sometimes over many years. By whatever reason, in 2002 some data might be in column D which is in 2003 to 2005 in column E and since 2006 in column F. Doing the consolidation in VBA is almost as painful as doing it manually (unifying the original spreadsheets), while the latter has the extra challenge to be error-prone. Our silver bullet is Smalltalk. I create a real object model for the business presented in the spreadsheets, I use COM Connect to populate the object model, I use Smalltalk to transform the objects (consolidate), and use COM Connect to create Excel spreadsheets in the format desired for the consolidated information.

http://www.vimeo.com/24465651

 

For more information about the speakers at Smalltalk Solutions 2011, see below:


 

I am really looking forward to Smalltalk Solutions 2011. Over the last couple of years, Smalltalk has again improved, has become a very strong system to professionally model complex situations throughout the industries. And runs mission critical system 24/7. I am eager to learn more at Smalltalk Solutions 2011!–- Georg Heeg, STIC Executive Director

Smalltalk Solutions has always been an interesting conference, with lots of great presentations. I always leave with my head full of new ideas!–- Arden Thomas, Cincom Smalltalk Product Manager